CS50_Labs/Lab7/movies/11.sql

7 lines
222 B
SQL

select title from movies
join stars on people.id = stars.person_id
join people on stars.movie_id = movies.id
join ratings on movies.id = ratings.movie_id
where people.name = "Chadwick Boseman"
order by rating desc
limit 5;