wk7/pset/movies/13.sql


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

SELECT name
FROM people
WHERE id IN (
    SELECT person_id
    FROM stars
    WHERE movie_id = (
        SELECT id
        FROM movies
        WHERE id IN (
            SELECT movie_id
            FROM stars
            WHERE person_id = (
                SELECT id
                FROM people
                WHERE name = "Kevin Bacon"
                AND year = 1958
            )
        )
    )
)
;