-- Primary Query: Top Categories Q3
SELECT category_name, SUM(revenue) as q3_revenue
FROM sales
WHERE region = 'North America'
AND quarter = 'Q3'
GROUP BY category_name
ORDER BY q3_revenue DESC
LIMIT 1;
-- Secondary Query: QoQ Comparison
WITH q2_sales AS (
SELECT category_name, SUM(revenue) as prev_rev
FROM sales WHERE region = 'North America' AND quarter = 'Q2' GROUP BY category_name
)
SELECT s.category_name, SUM(s.revenue) as curr_rev, q.prev_rev
FROM sales s
JOIN q2_sales q ON s.category_name = q.category_name
WHERE s.region = 'North America' AND s.quarter = 'Q3'
GROUP BY s.category_name, q.prev_rev;