Why SQL NOT IN returns no rows when the column has NULL

A tiny SQLite demo of the three-valued logic trap: one NULL in a NOT IN list can wipe every row. Fixes with IS NOT NULL, NOT EXISTS, and a LEFT JOIN.