Window Function SUM() With NULL Partition?!

Window functions with NULL partitions create chaos! SUM OVER (PARTITION BY NULL) behaves unexpectedly. This breaks analytics! Watch!

#sql #sqltricks #database #sqltutorial #windowfunctions #nullpartition #sqlquiz #codingchallenge #sqlshorts #sqlbugs #analytics #sqlwtf

https://www.youtube.com/watch?v=66BfdH3qLsg