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

Movies (Movies/Actors/Ratings)

Loading database engine...

Hint

Solution

Search

Search lessons, functions, examples, and practice problems