ผลรวมสะสมเคลื่อนที่ของเหรียญรางวัลแต่ละประเทศ

WITH Country_Medals AS (
  SELECT
    Year, Country, COUNT(*) AS Medals
  FROM Summer_Medals
  GROUP BY Year, Country)

SELECT
  Year, Country, Medals,
  -- Calculate each country's 3-game moving total
  ___ OVER
    (PARTITION BY ___
     ORDER BY Year ASC
     ROWS BETWEEN
     ___ AND ___) AS Medals_MA
FROM Country_Medals
ORDER BY Country ASC, Year ASC;