IS NULL Checking
Beginner
A data-quality audit needs to find incomplete user records. Some users have no email recorded at all (the value is NULL). One user has an empty string instead, which is a different thing and is not part of this audit.
Write a query returning all columns of users where email IS NULL.
Constraints
- Return all columns
- Only rows where
emailis NULL - An empty string
''is not NULL
Hints
Hint 1
= NULL never matches anything; SQL has a dedicated operator.
Hint 2
Use IS NULL, and IS NOT NULL for the opposite.
Keywords
db
SQL
Run your code to see results
No results yet
Run your code to check it against the examples, or submit to run every test.