Session Ready
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.