CS50_Labs/Lab7/movies/7.sql

5 lines
129 B
SQL

select title, rating from movies
join ratings on movies.id = ratings.movie_id
where year = 2010
order by rating desc, title asc;