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 movie_id IN (
        SELECT movie_id
        FROM stars
        WHERE person_id = (
            SELECT id
            FROM people
            WHERE name = 'Jennifer Lawrence'
        )
    )
);