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

Exercise

Minimum country medals by year

So far, you've seen MAX and SUM, aggregate functions normally used with GROUP BY, being used as window functions. You can also use the other aggregate functions, like MIN, as window functions.

Instructions

100 XP
  • Return the year, medals earned, and minimum medals earned so far.