1. Learn
    2. /
  2. Courses
    3. /
  3. Applying SQL to Real-World Problems

Exercise

Aggregating finances

In this exercise you would like to learn more about the differences in payments between the customers who are active and those who are not.

Instructions

100 XP
  • Find out the differences in their total number of payments by COUNT()ing the payment_id.
  • Find out the differences in their average payments by using AVG().
  • Find out the differences in their total payments by using SUM().
  • Ensure the aggregate functions GROUP BY whether customer payments are active.