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