select 
    popu.PF_CODE as 都道府県コード,
    pr.PF_NAME as 都道府県名,
    (select TOTAL_AMT from POPU_TRANSITION popu2 where popu.PF_CODE = popu2.PF_CODE and popu2.SURVEY_YEAR = 2015) as 総人口2015年,
    (select TOTAL_AMT from POPU_TRANSITION popu2 where popu.PF_CODE = popu2.PF_CODE and popu2.SURVEY_YEAR = 2020) as 総人口2020年,
    round(CAST((select TOTAL_AMT from POPU_TRANSITION popu2 where popu.PF_CODE = popu2.PF_CODE and popu2.SURVEY_YEAR = 2020) as REAL) / CAST((select TOTAL_AMT from POPU_TRANSITION popu2 where popu.PF_CODE = popu2.PF_CODE and popu2.SURVEY_YEAR = 2015) as REAL) * 100) as 人口増加率
from POPU_TRANSITION popu
join PREFECTURE pr on pr.PF_CODE = popu.PF_CODE
group by popu.PF_CODE
order by 人口増加率 DESC, 都道府県コード
;