SELECT 
a.PF_CODE as 都道府県コード,
b.PF_NAME as 都道府県名,
a.amt_2015 as [総人口2015年],
a.amt_2020 as [総人口2020年],
a.zouka as 人口増加率
FROM (
        SELECT 
        a1.PF_CODE,
        a1.TOTAL_AMT as amt_2015,
        a2.TOTAL_AMT as amt_2020,
        ROUND(a2.TOTAL_AMT/CAST(a1.TOTAL_AMT as REAL)*100) as zouka
        FROM POPU_TRANSITION as a1
        INNER JOIN 
        (SELECT PF_CODE,TOTAL_AMT
        FROM POPU_TRANSITION 
        WHERE SURVEY_YEAR=2020) as a2
        ON a1.PF_CODE=a2.PF_CODE
        WHERE SURVEY_YEAR=2015) as a
INNER JOIN PREFECTURE as b
ON a.PF_CODE=b.PF_CODE
WHERE a.zouka>=100
ORDER BY a.zouka desc, a.PF_CODE asc
;