DVD Rental - Dates

dates.sql

-- SELECT p.*, 
-- p.payment_date::date,  
-- extract(year from p.payment_date),
-- extract(month from p.payment_date),
-- extract(day from p.payment_date)
-- 
-- FROM payment p
-- 
-- WHERE extract(month from p.payment_date) IN (1,2)

SELECT SUM(p.amount), MAX(p.amount), MIN(p.amount), to_char(p.payment_date, 'yyyy-mm')
FROM payment p
GROUP BY 4
ORDER BY 1 DESC