summaryrefslogtreecommitdiff
path: root/wk7/pset/movies
diff options
context:
space:
mode:
Diffstat (limited to 'wk7/pset/movies')
-rw-r--r--wk7/pset/movies/13.sql20
1 files changed, 20 insertions, 0 deletions
diff --git a/wk7/pset/movies/13.sql b/wk7/pset/movies/13.sql
index e69de29..1109cd1 100644
--- a/wk7/pset/movies/13.sql
+++ b/wk7/pset/movies/13.sql
@@ -0,0 +1,20 @@
+SELECT name
+FROM people
+WHERE id IN (
+ SELECT movie_id
+ FROM stars
+ WHERE person_id = (
+ SELECT id
+ FROM people
+ WHERE name = "Bradley Cooper"
+ )
+) AND (
+ SELECT movie_id
+ FROM stars
+ WHERE person_id = (
+ SELECT id
+ FROM people
+ WHERE name = "Jennifer Lawrence"
+ )
+)
+;