SELECT
  DISTRICT_NAME AS 都道府県名,
  TOTAL_AMT AS 総人口
FROM
  POPULATION
WHERE
  LVL = 2
GROUP BY
  DISTRICT_NAME
ORDER BY
  総人口
  DESC ;