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.
Bu egzersiz
Applying SQL to Real-World Problems
kursunun bir parçasıdırEgzersiz talimatları
- Find out the differences in their total number of payments by
COUNT()ing thepayment_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 BYwhether customer payments areactive.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
SELECT active,
___ AS num_transactions,
___ AS avg_amount,
___ AS total_amount
FROM payment AS p
INNER JOIN customer AS c
ON p.customer_id = c.customer_id
GROUP BY ___;