SELECT DISTRICT_NAME AS '都道府県名', TOTAL_AMT AS '総人口' FROM POPULATION WHERE LVL = 2 Order by TOTAL_AMT desc ;