Introduction
Exercises
6. Game production statistics by year

Instruction

Keep going! You're halfway through!

Exercise

Count how many games were released each year, what was the average cost of production and what was their average revenue.

Stuck? Here's a hint!

You'll need four columns:

  • production_year
  • COUNT(...)
  • AVG(...)
  • AVG(...)

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

GROUP BY production_year

Console

Code editor

Result

TableConsole