The IFNULL function is identical to the COALESCE scalar function
with two arguments. For more information, see COALESCE.
Example
When selecting the employee number (EMPNO) and salary (SALARY) from all
the rows in the EMPLOYEE table, if the salary is missing (that is, null),
then return a value of zero.