SELECT 
PREFECTURE.PF_CODE AS "都道府県コード",
PF_NAME  AS "都道府県名",
"2015".TOTAL_AMT AS "総人口2015年",
"2020".TOTAL_AMT AS "総人口2020年",
ROUND((CAST("2020".TOTAL_AMT AS FLOAT)/CAST("2015".TOTAL_AMT AS FLOAT)*100),0) AS "人口増加率"
FROM PREFECTURE
INNER JOIN POPU_TRANSITION AS "2015"
ON "2015".PF_CODE = PREFECTURE.PF_CODE
AND "2015".SURVEY_YEAR = 2015
INNER JOIN POPU_TRANSITION AS "2020"
ON PREFECTURE.PF_CODE = "2020".PF_CODE
AND "2020".SURVEY_YEAR = 2020
ORDER BY "増加率" DESC, "都道府県コード" ASC;