select
  DISTRICT_NAME 都道府県,
  sum(TOTAL_AMT) 人口
from
  population
where
  lvl = 2
group by DISTRICT_NAME
order by 人口 desc;