select 
    B.pf_code as 都道府県コード,
    B.pf_name as 都道府県名,
    AMT_2015 as 総人口2015年,
    AMT_2020 as 総人口2020年,
    CAST(ROUND(CAST(AMT_2020 AS REAL)/CAST(AMT_2015 AS REAL)*100,0) AS INT) AS 人口増加率
FROM (select PF_CODE,
    SUM(CASE WHEN SURVEY_YEAR = 2015 THEN TOTAL_AMT ELSE 0 END) AS AMT_2015,
    SUM(CASE WHEN SURVEY_YEAR = 2020 THEN TOTAL_AMT ELSE 0 END) AS AMT_2020
from POPU_TRANSITION
WHERE SURVEY_YEAR IN(2015,2020)
group by PF_CODE)as a,PREFECTURE as b
where a.pf_code = b.pf_code
AND AMT_2015 < AMT_2020
ORDER BY 人口増加率 DESC,都道府県コード