From 3caa9b7fe3be0879516c836a874d3cb683871e11 Mon Sep 17 00:00:00 2001
From: Fudgerboy <91767657+Fudgerboy@users.noreply.github.com>
Date: Mon, 20 May 2024 11:42:55 +0000
Subject: Mon, May 20, 2024, 4:42 AM -07:00

---
 wk7/pset/movies/13.sql | 11 +++++++++--
 1 file changed, 9 insertions(+), 2 deletions(-)

(limited to 'wk7/pset')

diff --git a/wk7/pset/movies/13.sql b/wk7/pset/movies/13.sql
index e8ca7a7..3d51903 100644
--- a/wk7/pset/movies/13.sql
+++ b/wk7/pset/movies/13.sql
@@ -4,8 +4,15 @@ WHERE id IN (
     SELECT person_id
     FROM stars
     WHERE movie_id = (
-        SELECT id
-        FROM movies
+        SELECT movie_id
+        FROM stars
+        WHERE person_id = (
+            SELECT id
+            FROM people
+            WHERE name = "Kevin Bacon"
+            AND birth = 1958
+        )
     )
+    NOT name = "Kevin Bacon"
 )
 ;
-- 
cgit v1.2.3