SELECT
  DISTRICT_NAME as "都道府県名",
  SUM(TOTAL_AMT) as "総人口"
FROM POPULATION
WHERE
  LVL = 2
group by TOTAL_AMT
order by TOTAL_AMT desc