select
    genzai.PF_CODE '都道府県コード',
    PREFECTURE.PF_NAME '都道府県名',
    kako.TOTAL_AMT '総人口2015年',
    genzai.TOTAL_AMT '総人口2020年',
    ROUND((100.0 * (genzai.TOTAL_AMT - kako.TOTAL_AMT))/genzai.TOTAL_AMT) + 100  '人口増加率'
from
(select * from POPU_TRANSITION where SURVEY_YEAR = 2015) kako
INNER JOIN (select * from POPU_TRANSITION where SURVEY_YEAR = 2020) genzai
ON kako.PF_CODE = genzai.PF_CODE AND kako.TOTAL_AMT < genzai.TOTAL_AMT
INNER JOIN PREFECTURE
ON genzai.PF_CODE = PREFECTURE.PF_CODE
ORDER BY 人口増加率 DESC
;