diff options
Diffstat (limited to 'wk7/pset')
-rw-r--r-- | wk7/pset/movies/12.sql | 8 |
1 files changed, 3 insertions, 5 deletions
diff --git a/wk7/pset/movies/12.sql b/wk7/pset/movies/12.sql index fdc2345..03e838b 100644 --- a/wk7/pset/movies/12.sql +++ b/wk7/pset/movies/12.sql @@ -3,15 +3,13 @@ FROM movies WHERE id IN ( SELECT movie_id FROM stars - WHERE person_id = ( + WHERE person_id IN ( SELECT id FROM people WHERE name = "Bradley Cooper" ) -) AND ( - SELECT movie_id - FROM stars - WHERE person_id = ( + AND + ( SELECT id FROM people WHERE name = "Jennifer Lawrence" |