SELECT
 P1.PF_CODE AS "都道府県コード",
 P2.PF_NAME AS "都道府県名",
 MAX(CASE WHEN P1.SURVEY_YEAR = 2015 THEN TOTAL_AMT END) AS "総人口2015年",
 MAX(CASE WHEN P1.SURVEY_YEAR = 2020 THEN TOTAL_AMT END) AS "総人口2020年",
 ROUND(1.00*MAX(CASE WHEN P1.SURVEY_YEAR = 2020 THEN TOTAL_AMT END)/MAX(CASE WHEN P1.SURVEY_YEAR = 2015 THEN TOTAL_AMT END),2)*100 AS "人口増加率"
FROM POPU_TRANSITION P1
 LEFT OUTER JOIN PREFECTURE P2 ON P1.PF_CODE = P2.PF_CODE
 WHERE P1.SURVEY_YEAR IN (2015,2020)
GROUP BY 1,2
ORDER BY 5 DESC, 1;