Exercise

All together now

Time to practice using ORDER BY, GROUP BY and HAVING together.

Now you're going to write a query that returns the average budget and average gross earnings for films in each year after 1990, if the average budget is greater than $60 million.

This is going to be a big query, but you can handle it!

Instructions 1/6

undefined XP

1
2
3
4
5
6

Get the release year, budget and gross earnings for each film in the films table.