From 92df00a8893c06e50571a2ae4aa3228a21a1420f Mon Sep 17 00:00:00 2001
From: Fudgerboy <91767657+Fudgerboy@users.noreply.github.com>
Date: Mon, 20 May 2024 11:31:27 +0000
Subject: Mon, May 20, 2024, 4:31 AM -07:00

---
 wk7/pset/movies/12.sql | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)

(limited to 'wk7')

diff --git a/wk7/pset/movies/12.sql b/wk7/pset/movies/12.sql
index e69de29..47663ff 100644
--- a/wk7/pset/movies/12.sql
+++ b/wk7/pset/movies/12.sql
@@ -0,0 +1,16 @@
+SELECT title
+FROM movies
+WHERE id IN (
+    SELECT movie_id
+    FROM stars
+    WHERE person_id = (
+        SELECT id
+        FROM people
+        WHERE name = "Bradley Cooper"
+    ) AND person_id = (
+        SELECT id
+        FROM people
+        WHERE name = "Jennifer Lawrence"
+    )
+)
+;
-- 
cgit v1.2.3