Task 7


#1

Task 7 Return the name and IMDb rating of every movie made after 2009 in alphabetical order.

SELECT * FROM movies 
WHERE year > 2009
ORDER BY name ACS;

I got alert of "ASC" syntax error


#2

Hello,
its only asking for two columns of data here, Name and IMDB rating, which is what we define after the SELECT clause. We define the table we want those columns for after. That may be what caused your error.

--SELECT name, imdb_rating FROM movies
WHERE year > 2009
ORDER BY name ASC;