select 
    PF.PF_CODE AS '都道府県コード',
    PF.PF_NAME AS '都道府県名',
    PT15.TOTAL_AMT AS '総人口2015年',
    PT20.TOTAL_AMT AS '総人口2020年',
    ROUND(CAST(PT20.TOTAL_AMT as REAL)/ CAST(PT15.TOTAL_AMT as REAL)*100, 0) AS '人口増加率'
from
    PREFECTURE PF 
    INNER JOIN POPU_TRANSITION as PT15
    ON PF.PF_CODE = PT15.PF_CODE
        AND PT15.SURVEY_YEAR = 2015
    INNER JOIN POPU_TRANSITION as PT20
    ON PF.PF_CODE = PT20.PF_CODE
        AND PT20.SURVEY_YEAR = 2020
where PT15.TOTAL_AMT < PT20.TOTAL_AMT
order by
    "人口増加率" desc,
    "PF.PF_code" asc;