summaryrefslogtreecommitdiff
path: root/wk7
diff options
context:
space:
mode:
Diffstat (limited to 'wk7')
-rw-r--r--wk7/pset/movies/12.sql6
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"