SELECT　P1.PF_CODE AS 都道府県コード, PREFECTURE.PF_NAME AS 都道府県名,  P1.TOTAL_AMT AS 総人口2015年, P2.TOTAL_AMT AS 総人口2020年, ROUND(CAST(P2.TOTAL_AMT AS REAL)/P1.TOTAL_AMT*100,0) AS 人口増加率 FROM (SELECT * FROM POPU_TRANSITION WHERE SURVEY_YEAR=2015) AS P1 INNER JOIN PREFECTURE ON P1.PF_CODE=PREFECTURE.PF_CODE INNER JOIN (SELECT * FROM POPU_TRANSITION WHERE SURVEY_YEAR=2020) AS P2 ON P2.PF_CODE=P1.PF_CODE WHERE 100<CAST(P2.TOTAL_AMT AS REAL)/P1.TOTAL_AMT*100 AND P1.TOTAL_AMT IS NOT NULL AND P2.TOTAL_AMT IS NOT NULL GROUP BY 都道府県名 ORDER BY 人口増加率 DESC,都道府県コード ASC;