SELECT 
a.PF_CODE AS 都道府県コード
,PF_NAME AS 都道府県名
,a.TOTAL_AMT AS 総人口2015年
,b.TOTAL_AMT AS 総人口2020年
,ROUNd(CAST(b.TOTAL_AMT AS REAL)*100/a.TOTAL_AMT) AS 人口増加率
FROM (SELECT SURVEY_YEAR
,PF_CODE
,TOTAL_AMT
,MALE_AMT
,FEMALE_AMT FROM POPU_TRANSITION
      WHERE SURVEY_YEAR = 2015) a
LEFT JOIN (SELECT SURVEY_YEAR
,PF_CODE
,TOTAL_AMT
,MALE_AMT
,FEMALE_AMT FROM POPU_TRANSITION
      WHERE SURVEY_YEAR = 2020) b
ON a.PF_CODE = b.PF_CODE
LEFT JOIN PREFECTURE c
  ON a.PF_CODE = c.PF_CODE
ORDER BY 人口増加率 DESC,都道府県コード