-- SQLite
SELECT DISTRICT_CODE, 
CASE
    WHEN DISTRICT_NAME ="" OR DISTRICT_NAME ISNULL THEN "不明"
    ELSE DISTRICT_NAME
END AS DISTRICT_NAME
, TOTAL_AMT, MALE_AMT, FEMALE_AMT
FROM POPULATION
ORDER BY DISTRICT_CODE;