Session Ready
Exercise

Moving maximum of Chinese athletes' medals

Frames allow you "peak" forwards or backward without first using the relative fetching functions, LAG and LEAD, to fetch previous rows' values into the current row.

Instructions
100 XP
  • Return the athletes, medals earned, and the maximum medals earned, comparing only the last two and current athletes, ordering by athletes' names in alphabetical order.