นักกีฬาคนแรกตามลำดับชื่อ

WITH All_Male_Medalists AS (
  SELECT DISTINCT
    Athlete
  FROM Summer_Medals
  WHERE Medal = 'Gold'
    AND Gender = 'Men')

SELECT
  -- Fetch all athletes and the first athlete alphabetically
  ___,
  ___ OVER (
    ORDER BY ___ ASC
  ) AS First_Athlete
FROM All_Male_Medalists;