SELECT PO1.PF_CODE AS '都道府県コード', PR.PF_NAME AS '都道府県名', PO1.TOTAL_AMT AS '総人口2015年', PO2.TOTAL_AMT AS '総人口2020年', CAST(PO2.TOTAL_AMT AS REAL)/PO1.TOTAL_AMT*100 AS '人口増加率' FROM POPU_TRANSITION AS PO1 JOIN (SELECT PF_CODE, TOTAL_AMT FROM POPU_TRANSITION WHERE SURVEY_YEAR=2020) AS PO2 ON PO1.PF_CODE=PO2.PF_CODE JOIN PREFECTURE AS PR ON PO1.PF_CODE=PR.PF_CODE WHERE PO1.SURVEY_YEAR=2015 ORDER BY 人口増加率 DESC, 都道府県コード ASC;