From 3a1473c9026dd27617ba94794ddfda091e7a7c19 Mon Sep 17 00:00:00 2001 From: Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> Date: Mon, 20 May 2024 11:33:07 +0000 Subject: Mon, May 20, 2024, 4:33 AM -07:00 --- wk7/pset/movies/12.sql | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) 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" -- cgit v1.2.3