Introduction
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 AvgCost column), and what was their average revenue (as the AvgRevenue column).
Stuck? Here's a hint!
You'll need four columns:
ProductionYear, COUNT(...) AS count, AVG(...) AS AvgCost, AVG(...) AS AvgRevenue
And you'll need to group your results by the ProductionYear column:
GROUP BY ProductionYear
