Skip to content
Aabha AI Academy
Skip to reading

SQL

03 Nulls

-- 03_nulls: Find a missing city
-- Read-only reference query. Setup must be loaded first.
SELECT customer_id, customer_name, COALESCE(city,'Unknown') AS city_label
FROM aabha_sql.customers WHERE city IS NULL ORDER BY customer_id;

Download this source file