Window Functions на пальцях і прикладах #sql

Онлайн курси від robot dreams: Advanced SQL для аналітики: https://robotdreams.cc/uk/course/1779...
SQL для аналітики https://robotdreams.cc/uk/course/sql-...
Cheat Sheet https://learnsql.com/blog/sql-window-...
Дані: https://www.kaggle.com/datasets/vince...
Квері: https://console.cloud.google.com/bigq...
Таймкоди 05:20 avg(column) over () 08:28 percent_rank() over(order by column) 13:35 row_number() over(partition by column order by column2) 17:02 first_value(column) over(partition by column order by column2) 20:10 lead/lag (column) over(partition by column order by column2) 32:10 avg(column) over (order by column rows between … )