select pr.PF_CODE as "都道府県コード"
      ,pr.PF_NAME as "都道府県名"
      ,po1.TOTAL_AMT as "総人口2015年"
      ,po2.TOTAL_AMT as "総人口2020年"
      ,round(cast(po2.TOTAL_AMT as REAL) / cast(po1.TOTAL_AMT as REAL) * 100) as "人口増加率"
from PREFECTURE pr
     LEFT OUTER JOIN POPU_TRANSITION po1
     ON pr.PF_CODE = po1.PF_CODE
     LEFT OUTER JOIN POPU_TRANSITION po2
     ON pr.PF_CODE = po2.PF_CODE
where po1.SURVEY_YEAR = 2015
and   po2.SURVEY_YEAR = 2020
and   po1.TOTAL_AMT < po2.TOTAL_AMT
order by "人口増加率" desc
        ,"都道府県コード"
;