05 Missing

-- 05_missing: Count rows and known values
-- Read-only reference query. Setup must be loaded first.
SELECT COUNT(*) AS customers, COUNT(city) AS known_cities,
 COUNT(*)-COUNT(city) AS missing_cities FROM aabha_sql.customers;