with t0 as 
(
    select 
        DISTRICT_CODE, 
        case when DISTRICT_NAME is NULL or DISTRICT_NAME='' then '不明' else district_code end as DISTRICT_NAME, 
        TOTAL_AMT, MALE_AMT, FEMALE_AMT
        from population
)

select * from t0