diff options
| author | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-20 11:33:07 +0000 |
|---|---|---|
| committer | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-20 11:33:07 +0000 |
| commit | 3a1473c9026dd27617ba94794ddfda091e7a7c19 (patch) | |
| tree | 435a1f038ff723423112ce495cf8359f38d7148d /wk7/pset/movies/12.sql | |
| parent | 92df00a8893c06e50571a2ae4aa3228a21a1420f (diff) | |
Mon, May 20, 2024, 4:33 AM -07:00
Diffstat (limited to 'wk7/pset/movies/12.sql')
| -rw-r--r-- | wk7/pset/movies/12.sql | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/wk7/pset/movies/12.sql b/wk7/pset/movies/12.sql index 47663ff..fdc2345 100644 --- a/wk7/pset/movies/12.sql +++ b/wk7/pset/movies/12.sql @@ -7,7 +7,11 @@ WHERE id IN ( SELECT id FROM people WHERE name = "Bradley Cooper" - ) AND person_id = ( + ) +) AND ( + SELECT movie_id + FROM stars + WHERE person_id = ( SELECT id FROM people WHERE name = "Jennifer Lawrence" |