Exercise

First athlete by name

It's often useful to get the first or last value in a dataset to compare all other values to it. With absolute fetching functions like FIRST_VALUE, you can fetch a value at an absolute position in the table, like its beginning or end.

Instructions

100 XP
  • Return all athletes and the first athlete ordered by alphabetical order.