SELECT pf_code                                         as 都道府県コード,
       pf_name                                         as 都道府県名,
       amt2015                                         as 総人口2015年,
       amt2020                                         as 総人口2020年,
       round(cast(amt2020 as real) / amt2015 * 100, 0) as 人口増加率
from (((select pf_code as pf, TOTAL_AMT as amt2015 from POPU_TRANSITION where SURVEY_YEAR is 2015) a
    inner join (select pf_code as pf, TOTAL_AMT as amt2020 from POPU_TRANSITION where SURVEY_YEAR is 2020) b
       on a.pf = b.pf) c
    inner join prefecture p on c.pf = p.pf_code)
where amt2020 > amt2015
order by 人口増加率 desc, 都道府県コード asc;