Kickstart 2020 with new opportunities! - hours only!Up to 80% off on all courses and bundles.-Close
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).