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