select
    district_name as '都道府県',
    total_amt as '総人口'
from
    population
where
    district_name glob '*[都道府県]'
order by
    総人口 desc
;