☰
$
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
/
lag-lead
[challenge]
lesson 31
LAG and LEAD
>
theory
examples
[2]
challenges
[0/3]
loading company.db…
← prev:
PARTITION BY
next:
Running Totals and Moving Averages
→
$
tools
▸