Save up to $499! Grab all Python courses for$49 or all online courses we’ve ever launched for only \$169. Only Feb 11-16. Happy Valentine's!
Introduction
FIRST_VALUE, LAST_VALUE, NTH_VALUE
Summary

## Instruction

Alright. Take a look at the very first example:

SELECT
name,
opened,

The analytic function here is LEAD(name). LEAD with a single argument in the parentheses looks at the next row in the given order and shows the value in the column specified as the argument. Take a look:
Run the template from the instruction and study the result of LEAD(name).