select
district_code as "地区コード"
,case when district_name is null or district_name = '' then '不明' else district_name end as "地区名" 
,total_amt as "総数"
,male_amt as "男性数"
,female_amt as "女性数"
from
population
;