diff options
| author | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 04:53:45 +0000 |
|---|---|---|
| committer | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 04:53:45 +0000 |
| commit | 0b68b3b0b5076b94f9eed9f234a9c52ac4f4b989 (patch) | |
| tree | 10da14e1ac480bb8a46c4072d32a724a021ff860 /wk7/pset | |
| parent | ff328252aca63608c65ce5eedf6d0aaa3adb841a (diff) | |
Mon, May 20, 2024, 9:53 PM -07:00
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" |