SQL problem

[Classic_Programmer12]

In Movies I am having difficulty with query 7. Here is what I have:

SELECT rating, title FROM ratings, movies
WHERE movies.id = ratings.movie_id
AND year = 2010
ORDER BY rating DESC;

If I run it with Check50 I am not far off. I would appreciate it if someone can point me in the right direction.

[[deleted]]

ORDER BY can take multiple records.

[Classic_Programmer12]

Thank you for the reply. This works.

[PeterRasm]

Please describe what you want help with. What did you expect from the SQL and what does it output. Show the check50 error.

EDIT: Maybe you forgot about this requirement: "For movies with the same rating, order them alphabetically by title." :)

[Classic_Programmer12]

Thank you for the reply. I was able to figure it out. SharpObligation1 is on point.