SELECT A.PF_CODE AS 都道府県コード, C.PF_NAME AS 都道府県名, A.TOTAL_AMT AS 総人口2015年, B.TOTAL_AMT AS 総人口2020年, 
       round(100.0*B.TOTAL_AMT/A.TOTAL_AMT) AS 人口増加率
FROM POPU_TRANSITION AS A
JOIN PREFECTURE AS C ON A.PF_CODE=C.PF_CODE AND A.SURVEY_YEAR=2015
JOIN POPU_TRANSITION AS B ON A.PF_CODE=B.PF_CODE AND B.SURVEY_YEAR=2020
WHERE A.TOTAL_AMT < B.TOTAL_AMT
ORDER BY round(100.0*B.TOTAL_AMT/A.TOTAL_AMT) DESC, A.PF_CODE