Project: Analyzing Motorcycle Part Sales

-- Start coding here
SELECT  
	product_line,
	CASE 
	WHEN EXTRACT(month from date) = 6 THEN 'June'
	WHEN EXTRACT(month from date) = 7 THEN 'July'
	WHEN EXTRACT(month from date) = 8 THEN 'August'
	ELSE 'n/a'
	END AS month,
	warehouse,
	ROUND(SUM(total * (1 - payment_fee))::NUMERIC,2) AS net_revenue

FROM sales 
WHERE client_type = 'Wholesale'
GROUP BY product_line, month, warehouse, payment_fee ;

sELECT *
FROM sales