a8m88·13 ปีที่แล้ว·discussUsing COALESCE here is correct, but sum() returns NULL if there were no non-NULL inputs, so COALESCE should go around it:COALESCE(sum(salary), 0)
COALESCE(sum(salary), 0)