-- P8. Rank products by revenue within each category. (revenue - LAG(revenue) OVER (ORDER BY month)) / NULLIF(LAG(revenue) OVER (ORDER BY month), 0) * 100, 1 MAX(CASE WHEN rn = 1 THEN order_date END) ...