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

Perfect! Here's the last one!

Exercise

We're interested in good games produced between 2000 and 2009. A good game is a game that got rating higher than 6 and was profitable. For each company show company name, its total revenue from good games produced between 2000 and 2009 (as the revenue_sum column), and the number of good games it produced in this period (as the number_of_games column). Only show companies with good-game revenue over 4 000 000.

Stuck? Here's a hint!

Remember that profitable means that the sum of revenues was higher than the sum of production cost.