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