select
 p.PF_CODE as 都道府県コード
, p.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) as 人口増加率
from PREFECTURE p
     left join POPU_TRANSITION pt15
       on pt15.PF_CODE = p.PF_CODE
       and pt15.SURVEY_YEAR = 2015
     left join POPU_TRANSITION pt20
       on pt20.PF_CODE = p.PF_CODE
       and pt20.SURVEY_YEAR = 2020
order by 人口増加率 desc
, p.PF_CODE