Help with Problem 13 in Query Project


#1

Return 10 movies with an IMDb rating greater than 8 sorted by their genre.

What is the code for sorting by genre?


#2

Could you provide us with the link to the lesson...??


#3

To sort by genre, you could use an ORDER BY clause. It can be ascending (ASC) or descending (DESC).

SELECT * 
FROM movies
WHERE imdb_rating > 8
ORDER BY genre ASC
LIMIT 10;

#4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.