On January 21th at 14:15 UTC , progression through exercises will be unavailable for 10 minutes due to a planned maintenance break.
Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Exercises

Instruction

Keep going! You're halfway through!

Exercise

Count how many games were released each year (as the count column), what was the average cost of production (as the avg_cost column), and what was their average revenue (as the avg_revenue column).

Stuck? Here's a hint!

You'll need four columns:

  production_year,
COUNT(...) AS count,
AVG(...) AS avg_cost,
AVG(...) AS avg_revenue


And you'll need to group your results by the production_year column:

GROUP BY production_year