Numbering Olympic games in descending order

You've already numbered the rows in the Summer Medals dataset. What if you need to reverse the row numbers so that the most recent Olympic games' rows have a lower number?

This exercise is part of the course

PostgreSQL Summary Stats and Window Functions

View Course

Exercise instructions

  • Assign a number to each year in which Summer Olympic games were held so that rows with the most recent years have lower row numbers.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

SELECT
  Year,
  -- Assign the lowest numbers to the most recent years
  ___ OVER (___) AS Row_N
FROM (
  SELECT DISTINCT Year
  FROM Summer_Medals
) AS Years
ORDER BY Year;