前三分位、中三分位、後三分位
將資料切成三等分或四分位,常用來了解資料集中的數值如何分布。針對前三分位、中三分位、後三分位分別計算摘要統計(平均、總和、標準差等),可以幫助你判斷你的數值大致符合哪種分布。
本練習屬於課程
PostgreSQL 統計摘要與視窗函式
動手互動練習
試著完成這個範例程式碼,體驗一下這個練習。
WITH Athlete_Medals AS (
SELECT Athlete, COUNT(*) AS Medals
FROM Summer_Medals
GROUP BY Athlete
HAVING COUNT(*) > 1)
SELECT
Athlete,
Medals,
-- Split athletes into thirds by their earned medals
___ ___ ___ AS Third
FROM Athlete_Medals
ORDER BY Medals DESC, Athlete ASC;