SELECT
PF_CODE AS "都道府県コード"
, PF_NAME AS "都道府県名"
, amt_2015 AS "総人口2015年"
, amt_2020 AS "総人口2020年"
, ROUND(100.0 * amt_2020 / amt_2015) AS "人口増加率"

FROM
(
SELECT

pt.PF_CODE
, p.PF_NAME
, MAX(CASE WHEN SURVEY_YEAR = 2015 THEN TOTAL_AMT ELSE 0 END) AS amt_2015
, MAX(CASE WHEN SURVEY_YEAR = 2020 THEN TOTAL_AMT ELSE 0 END) AS amt_2020


FROM
POPU_TRANSITION AS pt

LEFT OUTER JOIN
PREFECTURE AS p

ON
p.PF_CODE = pt.PF_CODE

WHERE
pt.SURVEY_YEAR in (2015, 2020)

GROUP BY 
pt.PF_CODE
, p.PF_NAME
)

ORDER BY 
5 desc
, 1