wk7/pset/movies/12.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

SELECT title
FROM movies
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"
    )
)
;