Skip to content
SQLSimplified
mediummovieswindowcte

Highest Rated Movie Per Genre

Problem

Return the highest-rated movie (by Critics avg score) in each genre, with genre, title, and avg_score.

Try It

Movies (Movies/Actors/Ratings)

Loading database engine...

Hint

Solution

Search

Search lessons, functions, examples, and practice problems