1. Learn
    2. /
  2. Courses
    3. /
  3. PostgreSQL Summary Stats and Window Functions

Exercise

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?

Instructions

100 XP
  • 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.