From 12d30dbe343adbe6a14051d73a91c9cebd956f88 Mon Sep 17 00:00:00 2001
From: Fudgerboy <91767657+Fudgerboy@users.noreply.github.com>
Date: Mon, 20 May 2024 11:38:26 +0000
Subject: Mon, May 20, 2024, 4:38 AM -07:00

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

(limited to 'wk7')

diff --git a/wk7/pset/movies/13.sql b/wk7/pset/movies/13.sql
index 1109cd1..80e24fe 100644
--- a/wk7/pset/movies/13.sql
+++ b/wk7/pset/movies/13.sql
@@ -1,20 +1,21 @@
 SELECT name
 FROM people
 WHERE id IN (
-    SELECT movie_id
+    SELECT person_id
     FROM stars
-    WHERE person_id = (
+    WHERE movie_id = (
         SELECT id
-        FROM people
-        WHERE name = "Bradley Cooper"
-    )
-) AND (
-    SELECT movie_id
-    FROM stars
-    WHERE person_id = (
-        SELECT id
-        FROM people
-        WHERE name = "Jennifer Lawrence"
+        FROM movies
+        WHERE id IN (
+            SELECT movie_id
+            FROM stars
+            WHERE person_id = (
+                SELECT id
+                FROM people
+                WHERE name = "Kevin Bacon"
+                AND year = 1958
+            )
+        )
     )
 )
 ;
-- 
cgit v1.2.3