Handling NULL Values

NULL represents missing or unknown data. You cannot use = to check for NULL.

Correct Syntax

-- Find rows where email is missing
SELECT * FROM customers WHERE email IS NULL;
-- Find rows where email exists
SELECT * FROM customers WHERE email IS NOT NULL;

Your Task

Find all customers who have not provided an email address.