SELECT 
PR.PF_CODE AS "都道府県コード", 
PR.PF_NAME AS "都道府県", 
PT2015.TOTAL_AMT AS "総人口2015年", 
PT2020.TOTAL_AMT AS "総人口2020年", 
ROUND(CAST(PT2020.TOTAL_AMT AS real) / CAST(PT2015.TOTAL_AMT AS real) * 100) AS "人口増加率"
FROM PREFECTURE AS PR 
INNER JOIN POPU_TRANSITION AS PT2015 
ON PR.PF_CODE = PT2015.PF_CODE AND PT2015.SURVEY_YEAR = 2015
INNER JOIN POPU_TRANSITION AS PT2020 
ON PR.PF_CODE = PT2020.PF_CODE AND PT2020.SURVEY_YEAR = 2020
WHERE PT2015.TOTAL_AMT < PT2020.TOTAL_AMT
ORDER BY "人口増加率" DESC, "都道府県コード"
;