1. Learn
  2. /
  3. Courses
  4. /
  5. Intermediate SQL Queries

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.