NULL in SQL: Why = NULL Finds Nothing and What to Write Instead

WHERE assignee = NULL returns 0 of 10 rows, every time. What NULL actually means, IS NULL, the NOT IN trap, COALESCE, and how NULLs quietly move your averages.