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