select distinct PF.PF_CODE as 都道府県コード, PF.PF_NAME as 都道府県名, PO2015.TOTAL_AMT as 総人口2015年, PO2020.TOTAL_AMT as 総人口2020年,
ROUND(100*CAST(PO2020.TOTAL_AMT as real)/CAST(PO2015.TOTAL_AMT as real)) as 人口増加率
from POPU_TRANSITION as PO
    INNER JOIN PREFECTURE as PF
    on PF.PF_CODE = PO.PF_CODE
    INNER JOIN POPU_TRANSITION as PO2020
    on PO2020.SURVEY_YEAR = 2020 and PO2020.PF_CODE = PF.PF_CODE
    INNER JOIN POPU_TRANSITION as PO2015
    on PO2015.SURVEY_YEAR = 2015 and PO2015.PF_CODE = PF.PF_CODE
where PO2020.TOTAL_AMT > PO2015.TOTAL_AMT
order by 人口増加率 DESC, 都道府県コード ASC;