Help with Problem 13 in Query Project

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

What is the code for sorting by genre?

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

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;

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