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