Dvd Rental Tutorial 2 PG

video2.sql

SELECT p.customer_id, c.first_name,
SUM(p.amount)::money, COUNT(*), 
SUM(p.amount)/COUNT(*) as AVG_RENTAL_VALUE
FROM payment p LEFT JOIN customer c ON p.customer_id = c.customer_id
WHERE p.customer_id > 300 AND c.first_name like '%b%'
GROUP BY 1,2
HAVING COUNT(*) > 20 -- having is when you filter on aggregates, is a where clause for aggregates
ORDER BY 4 DESC