diff options
Diffstat (limited to 'wk7/pset')
-rw-r--r-- | wk7/pset/movies/13.sql | 25 |
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 + ) + ) ) ) ; |