Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

SQL Practice Set in MS SQL Server

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 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