NULLs in a result look like gaps and break arithmetic, since anything plus NULL is NULL. COALESCE returns the first value in its list that is not NULL, so you can show 0 or "N/A" instead. Use it for display and for maths on columns that may be empty, like a bonus column. It does not change the stored data, only the value in this query's result.