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

Instruction

There's nothing that can stop you! Here's the next one.

Exercise

For each company, select its name, the number of games it produced (as the number_of_games column), the average cost of production (as the avg_cost column). Show only these companies that produced more than one game.

Stuck? Here's a hint!

You cannot use aggregate functions in the WHERE clause. Use them in the HAVING clause:

GROUP BY company
HAVING count(company) > 1