select PREFECTURE.PF_CODE as "都道府県コード"
      ,PREFECTURE.PF_NAME as "都道府県名"
      ,t1.totalPop2015 as "総人口2015年"
      ,t2.totalPop2020 as "総人口2020年"
      ,round(cast(t2.totalPop2020 as double) / cast(t1.totalPop2015 as double) * 100) as "人口増加率"
    from (select PF_CODE, TOTAL_AMT as "totalPop2015" from POPU_TRANSITION where SURVEY_YEAR = 2015) as t1
        inner join (select PF_CODE, TOTAL_AMT as "totalPop2020" from POPU_TRANSITION where SURVEY_YEAR = 2020) as t2
            on t1.PF_CODE = t2.PF_CODE
        inner join PREFECTURE
            on t1.PF_CODE = PREFECTURE.PF_CODE
    where cast(t2.totalPop2020 as double) / cast(t1.totalPop2015 as double) > 1.0
    order by "人口増加率" desc, t1.PF_CODE asc;