SELECT
    DISTRICT_CODE,
    CASE WHEN COALESCE(DISTRICT_NAME, '') <> '' THEN DISTRICT_NAME ELSE '不明' END DISTRICT_NAME,
    TOTAL_AMT,
    MALE_AMT,
    FEMALE_AMT
FROM
    POPULATION
ORDER BY
    DISTRICT_CODE
;