with WORK AS (
    select  pop.PF_CODE "都道府県コード"
    ,       pre.PF_NAME "都道府県名"
    ,       SUM(CASE WHEN pop.SURVEY_YEAR = 2015 THEN pop.TOTAL_AMT ELSE 0 END) "総人口2015年"
    ,       SUM(CASE WHEN pop.SURVEY_YEAR = 2020 THEN pop.TOTAL_AMT ELSE 0 END) "総人口2020年"
    from POPU_TRANSITION pop
    inner join PREFECTURE pre
       on pre.PF_CODE= pop.PF_CODE
    where pop.SURVEY_YEAR IN (2015, 2020)
    group by pop.PF_CODE, pre.PF_NAME
)
select  wk.*
,       ROUND(wk."総人口2020年" * 100.0 / (wk."総人口2015年" + wk."総人口2020年"), 0) "人口増加率"
from WORK wk
order by "人口増加率" desc, "都道府県コード"