Post Thread

A Old way: handling NULL specifically

SELECT
FROM users
WHERE country_code != 'US' OR country_code IS NULL

Or wrapping in COALESCE

SELECT
FROM users
WHERE COALESCE (country_code, "N/A') != 'US"

New way!

SELECT
FROM users
WHERE country code IS DISTINCT FROM 'US'