diff options
| author | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 04:55:34 +0000 |
|---|---|---|
| committer | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 04:55:34 +0000 |
| commit | 6fea4151ad16c0f57db470594646ed2148dc4670 (patch) | |
| tree | 8ee3e99d33fde3001a5212f9c0dcd2e217dd406c /wk7/pset/movies/12.sql | |
| parent | 0b68b3b0b5076b94f9eed9f234a9c52ac4f4b989 (diff) | |
Mon, May 20, 2024, 9:55 PM -07:00
Diffstat (limited to 'wk7/pset/movies/12.sql')
| -rw-r--r-- | wk7/pset/movies/12.sql | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/wk7/pset/movies/12.sql b/wk7/pset/movies/12.sql index 03e838b..fdc2345 100644 --- a/wk7/pset/movies/12.sql +++ b/wk7/pset/movies/12.sql @@ -3,13 +3,15 @@ FROM movies WHERE id IN ( SELECT movie_id FROM stars - WHERE person_id IN ( + WHERE person_id = ( SELECT id FROM people WHERE name = "Bradley Cooper" ) - AND - ( +) AND ( + SELECT movie_id + FROM stars + WHERE person_id = ( SELECT id FROM people WHERE name = "Jennifer Lawrence" |