SELECT
  a.pf_code AS "都道府県コード",
  c.pf_name AS "都道府県名",
  a.total_amt AS "総人口2015年",
  b.total_amt AS "総人口2020年",
  ROUND(
    CAST(b.total_amt AS REAL) / CAST(a.total_amt AS REAL) * 100
  ) AS "人口増加率"
FROM
  (
    SELECT
      *
    FROM
      popu_transition
    WHERE
      survey_year = 2015
  ) a
  JOIN (
    SELECT
      *
    FROM
      popu_transition
    WHERE
      survey_year = 2020
  ) b ON a.pf_code = b.pf_code
  JOIN prefecture c on a.pf_code = c.pf_code
WHERE
  b.total_amt > a.total_amt
ORDER BY
  "人口増加率" DESC,
  "都道府県コード" ASC;