SUM - AVG With Zero Rows Returns WHAT?!

Aggregate functions with zero rows return NULL, not zero! SUM of nothing is NULL, not 0. This breaks aggregate logic! Watch!

#sql #sqltricks #database #sqltutorial #aggregate #zerorows #sqlquiz #codingchallenge #sqlshorts #sqlbugs #aggregatefunctions #sqlwtf

https://www.youtube.com/watch?v=fPdWHWUDZDs