Introduction
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
