Sql: how to handle null values in queries?

Example:

SELECT * FROM employees WHERE salary IS NULL;
Handling NULL values in SQL can sometimes be tricky. NULL represents missing or unknown data. It is not the same as zero or a blank space.

Solution:

SELECT COALESCE(salary, 0) FROM employees;

Beginner's Guide to SQL