SELECT 
	product_line,
    TO_CHAR(date, 'Month') AS month,
    warehouse,
    ROUND(SUM(total * (1-payment_fee))::numeric, 2) AS net_revenue
FROM sales
WHERE client_type = 'Wholesale'
GROUP BY product_line, warehouse, month
ORDER BY product_line, month, net_revenue DESC