Highest
Grossing
Items

Solution is locked until you decide to reveal it. Try the editor first, then open this when you want the reference answer.

WITH product_totals AS (
  SELECT
    category,
    product,
    SUM(spend) AS total_spend
  FROM product_spend
  WHERE EXTRACT(YEAR FROM transaction_date) = 2022
  GROUP BY category, product
),
ranked_products AS (
  SELECT
    category,
    product,
    total_spend,
    RANK() OVER (
      PARTITION BY category
      ORDER BY total_spend DESC
    ) AS product_rank
  FROM product_totals
)
SELECT
  category,
  product,
  total_spend
FROM ranked_products
WHERE product_rank <= 2;