Only this week, get the SQL Complete Track of 9 courses in a special prize of $330 $89!
Comparisons with NULL
10. Never trust a NULL
Functions with NULL
COALESCE to the rescue
Revision and practice


Good! As you can see, you need to keep your eyes open when you work with NULLs in your WHERE statements.

Remember – every time, think whether some columns can be NULLs. If they can, modify your query a tiny bit, just as we did in this section.


Press Next exercise to continue.