Output: Top 2 Per Category Count

How many rows remain after filtering rnk <= 2? WITH ranked AS (SELECT category_id, product_id, revenue, DENSE_RANK() OVER (PARTITION BY category_id ORDER BY revenue DESC) AS rnk FROM product_revenue) SELECT * FROM ranked WHERE rnk <= 2;