एथलीट मेडल्स के रनिंग टोटल

WITH Athlete_Medals AS (
  SELECT
    Athlete, COUNT(*) AS Medals
  FROM Summer_Medals
  WHERE
    Country = 'USA' AND Medal = 'Gold'
    AND Year >= 2000
  GROUP BY Athlete)

SELECT
  -- Calculate the running total of athlete medals
  ___,
  ___,
  ___ OVER (ORDER BY ___ ASC) AS Max_Medals
FROM Athlete_Medals
ORDER BY Athlete ASC;