Skip to content
Spinner
DataFrameas
revenue_by_product_line
variable
-- 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' 
       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
ORDER BY product_line, month, net_revenue DESC;