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