cinimex_creditdb_1.sql

WITH charge_by_categories AS (
	SELECT 
		ca.category_no, 
		ca.category_desc, 
		ch.charge_amt 
	FROM charge ch 
	JOIN category ca 
		ON ch.category_no = ca.category_no 
)
SELECT 
	cbc.category_desc, 
	SUM(cbc.charge_amt) summary_charge
FROM charge_by_categories cbc
GROUP BY cbc.category_no
ORDER BY summary_charge DESC 
LIMIT 5;