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