select
    DISTRICT_CODE,
    case when DISTRICT_NAME	is null or DISTRICT_NAME like '' or DISTRICT_NAME like 'NULL' then '不明' else DISTRICT_NAME end as DISTRICT_NAME,
    TOTAL_AMT,
    MALE_AMT,
    FEMALE_AMT
from POPULATION
group by DISTRICT_CODE;