https://cs50.harvard.edu/x/2020/psets/7/movies/

11.sql

-- Write a SQL query to list the titles of the five highest rated movies 
-- (in order) that Chadwick Boseman starred in, starting with the highest rated.
-- Your query should output a table with a single column for the title of each movie.
-- You may assume that there is only one person in the database with the name 
-- Chadwick Boseman.

SELECT title, rating
FROM movies
    JOIN ratings on movies.id = ratings.movie_id
    JOIN stars on movies.id = stars.movie_id
    JOIN people on stars.person_id = people.id
WHERE name = "Chadwick Boseman"
ORDER BY rating DESC
LIMIT 5

The query should output a single column table, not two. You can delete rating from the first SELECT