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.

100 XP

Identify the number of active and inactive customers by COUNT()ing them.
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.