-- https://topsic-contest.jp/contests/contest002/problems/contest002-4

select
    DISTRICT_CODE,
    case when DISTRICT_NAME is null or DISTRICT_NAME == '' then '不明' else DISTRICT_NAME end as DISTRICT_NAME,
    total_amt, male_amt, female_amt
from
    POPULATION
;