summaryrefslogtreecommitdiff
path: root/wk7/pset
diff options
context:
space:
mode:
Diffstat (limited to 'wk7/pset')
-rw-r--r--wk7/pset/movies/13.sql11
1 files changed, 9 insertions, 2 deletions
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"
)
;