select
    tbl1.PF_CODE '都道府県コード',
    tbl1.PF_NAME '都道府県名',
    tbl2_15.TOTAL_AMT '総人口2015年',
    tbl2_20.TOTAL_AMT '総人口2020年',
    round((cast(tbl2_20.TOTAL_AMT as float) - cast(tbl2_15.TOTAL_AMT as float)) / cast(tbl2_15.TOTAL_AMT as float) * 100 + 100, -1) '人口増加率'
    
from
    PREFECTURE as 'tbl1'
join
    POPU_TRANSITION as 'tbl2_15'
on
    tbl1.PF_CODE = tbl2_15.PF_CODE and tbl2_15.SURVEY_YEAR = 2015
join
    POPU_TRANSITION as 'tbl2_20'
on
    tbl1.PF_CODE = tbl2_20.PF_CODE and tbl2_20.SURVEY_YEAR = 2020
order by
    人口増加率 DESC,
    都道府県コード ASC

;