SQL Pattern: Top N per Group

WITH ranked AS (
    SELECT
        restaurant_id,
        menu_id,
        sales,

        ROW_NUMBER() OVER (
            PARTITION BY restaurant_id
            ORDER BY sales DESC
        ) AS rn

    FROM menu_sales
)

SELECT *
FROM ranked
WHERE rn <= 3;