UPDATE POPULATION
SET DISTRICT_NAME = NULLIF(DISTRICT_NAME, '');
SELECT
DISTRICT_CODE
, COALESCE(DISTRICT_NAME, '不明') AS DISTRICT_NAME
, TOTAL_AMT
, MALE_AMT
, FEMALE_AMT
FROM POPULATION
ORDER BY DISTRICT_CODE;