mcmenu_rank.sql

WITH ranks AS (
  SELECT
    menu_category,
    menu_items,
    energy_kcal,
    row_number() OVER (
      PARTITION BY menu_category
      ORDER BY
        energy_kcal DESC
    ) as energy_kcal_rank
  FROM
    menu
)
SELECT
  *
FROM
  ranks
WHERE
  energy_kcal_rank <= 3;