An all-NULL column hits SUM

Question

Accepted Answer

When every value in the column is NULL, SUM returns NULL - not 0. There are no non-NULL values to add. If you need 0 instead, wrap it: COALESCE(SUM(amount), 0). This behavior applies to all aggregate functions except COUNT(*), which always returns a number.