5. How do NULLs behave in SQL?
MediumSQL
Technical
Show model answer
NULL means unknown, so comparisons with = or <> return unknown rather than true. Use IS NULL / IS NOT NULL. Aggregates such as SUM and AVG ignore NULLs, while COUNT(*) counts all rows and COUNT(column) skips NULLs.
COALESCE replaces NULLs with a default; be careful, because NOT IN against a list containing NULL returns no rows.