SELECT
  code AS 都道府県コード,
  name AS 都道府県名,
  s2015 AS 総人口2015年,
  s2020 AS 総人口2020年,
  ROUND(CAST(s2020 AS REAL) / CAST(s2015 AS REAL) * 100) AS 人口増加率
FROM (
SELECT
  PREFECTURE.PF_CODE AS code,
  PREFECTURE.PF_NAME AS name,
  MAX(CASE WHEN SURVEY_YEAR = 2015 THEN TOTAL_AMT ELSE 0 END) AS s2015,
  MAX(CASE WHEN SURVEY_YEAR = 2020 THEN TOTAL_AMT ELSE 0 END) AS s2020
FROM PREFECTURE
INNER JOIN POPU_TRANSITION ON POPU_TRANSITION.PF_CODE = PREFECTURE.PF_CODE
GROUP BY PREFECTURE.PF_CODE, PREFECTURE.PF_NAME
)
ORDER BY 人口増加率 DESC, 都道府県コード ASC