運動員獎牌的累積總數
欄位的累積總數（又稱累積和）能幫助你判斷每一列對總和的貢獻。
本練習屬於課程
PostgreSQL 統計摘要與視窗函式
練習說明
- 回傳運動員姓名、他們獲得的獎牌數量，以及獎牌的累積總數，並依運動員姓名的英文字母順序排序。
動手互動練習
試著完成這個範例程式碼，體驗一下這個練習。
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;