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