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