select DISTRICT_NAME AS '都道府県名' ,TOTAL_AMT AS '総人口' from POPULATION A where A.lvl = 2 order by TOTAL_AMT desc