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 PostgreSQL

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