select DISTRICT_NAME as '都道府県名', TOTAL_AMT as '総人口' from POPULATION where LVL =2 group by DISTRICT_NAME order by TOTAL_AMT desc;