Writing Queries - TASK #7


#1

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

I am not sure how to do that.

SELECT * FROM movies WHERE year > 2009 BETWEEN 'A' AND 'Z';

#2

For sorting we would use ORDER BY, a column number or name and then ASC or DESC to set the direction of sort.

We only need to select two columns from the table, name and imdb_rating.


#4