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

Exercise

Last country by name

Just like you can get the first row's value in a dataset, you can get the last row's value. This is often useful when you want to compare the most recent value to previous values.

Instructions

100 XP
  • Return the year and the city in which each Olympic games were held.
  • Fetch the last city in which the Olympic games were held.