summaryrefslogtreecommitdiff
path: root/wk7/pset
diff options
context:
space:
mode:
Diffstat (limited to 'wk7/pset')
-rw-r--r--wk7/pset/movies/12.sql8
1 files changed, 3 insertions, 5 deletions
diff --git a/wk7/pset/movies/12.sql b/wk7/pset/movies/12.sql
index fdc2345..03e838b 100644
--- a/wk7/pset/movies/12.sql
+++ b/wk7/pset/movies/12.sql
@@ -3,15 +3,13 @@ FROM movies
WHERE id IN (
SELECT movie_id
FROM stars
- WHERE person_id = (
+ WHERE person_id IN (
SELECT id
FROM people
WHERE name = "Bradley Cooper"
)
-) AND (
- SELECT movie_id
- FROM stars
- WHERE person_id = (
+ AND
+ (
SELECT id
FROM people
WHERE name = "Jennifer Lawrence"