Get startedGet started for free

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.

This exercise is part of the course

PostgreSQL Summary Stats and Window Functions

View Course

Exercise instructions

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

Hands-on interactive exercise

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

WITH France_Medals AS (
  SELECT
    Year, COUNT(*) AS Medals
  FROM Summer_Medals
  WHERE
    Country = 'FRA'
    AND Medal = 'Gold' AND Year >= 2000
  GROUP BY Year)

SELECT
  ___,
  ___,
  ___ OVER (ORDER BY ___ ASC) AS Min_Medals
FROM France_Medals
ORDER BY Year ASC;
Edit and Run Code