select b.PF_CODE as 都道府県コード,b.PF_NAME as 都道府県名,
case a.SURVEY_YEAR when 2015 then a.TOTAL_AMT end as 総人口2015年,
case c.SURVEY_YEAR when 2020 then c.TOTAL_AMT end as 総人口2020年,
round(100 * cast(c.TOTAL_AMT as real) / cast (a.TOTAL_AMT as real)) as 人口増加率
from POPU_TRANSITION as a
inner join PREFECTURE as b
on a.PF_CODE = b.PF_CODE and a.SURVEY_YEAR = 2015
inner join POPU_TRANSITION as c
on a.PF_CODE = c.PF_CODE and c.SURVEY_YEAR = 2020
order by 人口増加率 desc, a.PF_CODE asc;