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