PSET7 7.sql Error

Question

The code gives the right amount of rows but is not passing the check50

SELECT movies.title, ratings.rating FROM movies
JOIN ratings ON ratings.movie_id = movies.id
WHERE year = 2010
ORDER BY title ASC

Answer 1

Use

ORDER BY rating DESC, title ASC

istead of

ORDER BY title ASC

This will give you proper formatting of all rows. Hope this helps. If it does, please check the tickmark.