SELECT PREFECTURE.PF_CODE as 都道府県コード,PREFECTURE.PF_NAME as 都道府県名,POPU_2015.TOTAL_AMT AS 総人口2015年, POPU_2020.TOTAL_AMT AS 総人口2020年 , ROUND(100.0*POPU_2020.TOTAL_AMT/POPU_2015.TOTAL_AMT) AS 人口増加率
FROM POPU_TRANSITION AS POPU_2015,POPU_TRANSITION AS POPU_2020,PREFECTURE
where POPU_2015.PF_CODE=PREFECTURE.PF_CODE AND POPU_2020.PF_CODE=PREFECTURE.PF_CODE and POPU_2015.SURVEY_YEAR=2015 and POPU_2020.SURVEY_YEAR=2020 and 人口増加率 >= 101
ORDER BY 人口増加率 desc