Skip to content
SQLSimplified
hardmoviescorrelated-subquery

Movies Above Their Genre's Average Budget

Problem

Write a query that returns the title, genre, and budget_millions of every movie whose budget is greater than the average budget of movies in its own genre, using a correlated subquery.

Try It

Loading playground environment...

Hint

Solution

Next Problem