Get top 3 rows per group

WITH ranked AS (
  SELECT product_id,
         category_id,
         revenue,
         ROW_NUMBER() OVER (
           PARTITION BY category_id
           ORDER BY revenue DESC
         ) AS rn
  FROM product_metrics
)
SELECT *
FROM ranked
WHERE rn <= 3;