select p.PF_CODE as 都道府県コード, p.PF_NAME as 都道府県名, p1.TOTAL_AMT as 総人口2015年, p2.TOTAL_AMT as 総人口2020年, round(cast(p2.TOTAL_AMT as real) / cast(p1.TOTAL_AMT as real) * 100, 0) as 人口増加率
from PREFECTURE p
join (select * from POPU_TRANSITION where SURVEY_YEAR == 2015) p1 on p1.PF_CODE == p.PF_CODE
join (select * from POPU_TRANSITION where SURVEY_YEAR == 2020) p2 on p2.PF_CODE == p.PF_CODE
order by 人口増加率 desc, p.PF_CODE asc;