0

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
0

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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .