diff options
| author | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 05:02:07 +0000 |
|---|---|---|
| committer | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 05:02:07 +0000 |
| commit | 409c933af61e2e4f7c75a3aaf067f53b483fbbff (patch) | |
| tree | 1a28c24bfdb2e4c66e4efd4ee48f65f2dc90585c /wk7/pset/movies/12.sql | |
| parent | 0f6e7948352433de58476f82fd8d05d832a8a857 (diff) | |
Mon, May 20, 2024, 10:02 PM -07:00
Diffstat (limited to 'wk7/pset/movies/12.sql')
| -rw-r--r-- | wk7/pset/movies/12.sql | 20 |
1 files changed, 10 insertions, 10 deletions
diff --git a/wk7/pset/movies/12.sql b/wk7/pset/movies/12.sql index fdc2345..08ab491 100644 --- a/wk7/pset/movies/12.sql +++ b/wk7/pset/movies/12.sql @@ -6,15 +6,15 @@ WHERE id IN ( WHERE person_id = ( SELECT id FROM people - WHERE name = "Bradley Cooper" + WHERE name = 'Bradley Cooper' ) -) AND ( - SELECT movie_id - FROM stars - WHERE person_id = ( - SELECT id - FROM people - WHERE name = "Jennifer Lawrence" + AND movie_id IN ( + SELECT movie_id + FROM stars + WHERE person_id = ( + SELECT id + FROM people + WHERE name = 'Jennifer Lawrence' + ) ) -) -; +); |