Introduction
Exercises
9. Productions statistics

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, the average cost of production. 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

Console

Code editor

Result

TableConsole