SELECT
PR.PF_CODE AS "都道府県コード"
,PR.PF_NAME AS "都道府県名"
,PP2015.TOTAL_AMT AS "総人口2015年"
,PP2020.TOTAL_AMT AS "総人口2020年"
,round(CAST(PP2020.TOTAL_AMT AS REAL) / CAST(PP2015.TOTAL_AMT AS REAL) * 100) AS "人口増加率"
FROM PREFECTURE PR
    inner join POPU_TRANSITION PP2015 on PR.PF_CODE = PP2015.PF_CODE
    AND PP2015.SURVEY_YEAR = 2015
    inner join POPU_TRANSITION PP2020 on PR.PF_CODE = PP2020.PF_CODE
    AND PP2020.SURVEY_YEAR = 2020
WHERE "人口増加率" >= 100
ORDER BY "人口増加率" DESC, "都道府県コード" ASC;