SELECT
  pfcd as '都道府県コード',
  pfnm as '都道府県名',
  amt2015 as '総人口2015年',
  amt2020 as '総人口2020年',
  rate as '人口増加率'
FROM
    (SELECT
      popu2020.PF_CODE as pfcd,
      PREFECTURE.PF_NAME as pfnm,
      popu2015.TOTAL_AMT as amt2015,
      popu2020.TOTAL_AMT as amt2020,
      ROUND(cast(popu2020.TOTAL_AMT as REAL) / cast(popu2015.TOTAL_AMT as REAL) * 100) as rate
    FROM (SELECT *
        FROM POPU_TRANSITION
        WHERE SURVEY_YEAR = 2020) as popu2020
    INNER JOIN (
        SELECT *
        FROM POPU_TRANSITION
        WHERE SURVEY_YEAR = 2015) as popu2015 ON popu2020.PF_CODE == popu2015.PF_CODE
    INNER JOIN PREFECTURE ON PREFECTURE.PF_CODE == popu2020.PF_CODE
    WHERE popu2020.TOTAL_AMT > popu2015.TOTAL_AMT)
ORDER BY rate DESC, pfcd asc