1. सीखें
    2. /
  2. पाठ्यक्रम
    3. /
  3. PostgreSQL Summary Stats and Window Functions
Connected

अभ्यास

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.

निर्देश

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