SUM(COALESCE(value, 0)) replaces each NULL value before summing. COALESCE(SUM(value), 0) makes the final result 0 if result is NULL.
SUM(COALESCE(value, 0))
NULL
COALESCE(SUM(value), 0)