select
    PF_CODE as 都道府県コード
    , PF_NAME as 都道府県名
    , popu2015.TOTAL_AMT as 総人口2015年
    , popu2020.TOTAL_AMT as 総人口2020年
    , round((cast(popu2020.TOTAL_AMT as real) / cast(popu2015.TOTAL_AMT as real)) * 100) as 人口増加率
from
    POPU_TRANSITION as popu2015
left join POPU_TRANSITION as popu2020
    using(PF_CODE)
left join PREFECTURE
    using(PF_CODE)
where 1=1
    and popu2015.SURVEY_YEAR = 2015
    and popu2020.SURVEY_YEAR = 2020
    and popu2015.TOTAL_AMT < popu2020.TOTAL_AMT
order by 5 desc, 1