☰
$
cd ../lessons
xp
0
# lessons
close
# window-functions
01
ROW_NUMBER, RANK, DENSE_RANK
02
PARTITION BY
03
LAG and LEAD
04
Running Totals and Moving Averages
>
05
FIRST_VALUE and LAST_VALUE
⤓ download notes (.md)
~
/
lessons
/
window-functions
/
first-last-value
[challenge]
lesson 33
FIRST_VALUE and LAST_VALUE
>
theory
examples
[2]
challenges
[0/3]
loading company.db…
← prev:
Running Totals and Moving Averages
next:
Views
→
$
tools
▸