SELECT DISTINCT(base.PF_CODE) as 都道府県コード,
       pref.PF_NAME as 都道府県名,
       sub1.t2015 as 総人口2015年,
       sub2.t2020 as 総人口2020年,
       ROUND( CAST(sub2.t2020 AS REAL) / CAST(sub1.t2015 AS REAL) * 100
       ) as 人口増加率
FROM 
    POPU_TRANSITION as base,
    PREFECTURE as pref
    ON base.PF_CODE = pref.PF_CODE,
    (SELECT PF_CODE, TOTAL_AMT as t2015 FROM POPU_TRANSITION where SURVEY_YEAR == 2015) as sub1
    ON base.PF_CODE = sub1.PF_CODE,
    (SELECT PF_CODE, TOTAL_AMT as t2020 FROM POPU_TRANSITION where SURVEY_YEAR == 2020) as sub2
    ON base.PF_CODE = sub2.PF_CODE
ORDER BY
    人口増加率 desc,
    都道府県コード ASC