wk7/pset/movies/11.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

SELECT title
FROM movies
JOIN ratings ON movies.id = ratings.movie_id
WHERE id IN (
    SELECT movie_id
    FROM stars
    WHERE person_id = (
        SELECT id
        FROM people
        WHERE name = "Chadwick Boseman"
    )
)
ORDER BY rating DESC
LIMIT 5
;