2 Queries Freeform Project Question 7 -


#1

Return the name and IMDB_rating of every movie made after 2009 in alphabetical order.

I am putting:

Select name, imdb_rating from movies WHERE year > '2009' and ORDER BY name ASC;

This phrase comes up with an error. Can someone please show me? thank you!


#2

I found It!

SELECT name, imdb_rating from movies WHERE year > '2009' GROUP BY imdb_rating ORDER BY name ASC;