Numbering Olympic athletes by medals earned
Row numbering can also be used for ranking. For example, numbering rows and ordering by the count of medals each athlete earned in the OVER clause will assign 1 to the highest-earning medalist, 2 to the second highest-earning medalist, and so on.
Bu egzersiz, kursun bir parçasıdır
PostgreSQL Summary Stats and Window Functions
Uygulamalı etkileşimli egzersiz
Bu egzersizi bu örnek kodu tamamlayarak deneyin.
SELECT
-- Count the number of medals each athlete has earned
___,
___ AS Medals
FROM Summer_Medals
GROUP BY Athlete
ORDER BY Medals DESC;