SELECT
    PF_CODE AS 都道府県コード,
    PF_NAME AS 都道府県名,
    p2015.TOTAL_AMT AS 総人口2015年,
    p2020.TOTAL_AMT AS 総人口2020年,
    ROUND(100 * CAST(p2020.TOTAL_AMT AS REAL) / CAST(p2015.TOTAL_AMT AS REAL)) AS 人口増加率
FROM PREFECTURE
LEFT JOIN (
SELECT
    *
FROM POPU_TRANSITION
WHERE
    survey_year = 2015
) AS p2015
USING(PF_CODE)
LEFT JOIN 
(
SELECT
    *
FROM POPU_TRANSITION
WHERE
    survey_year = 2020
) AS p2020
USING(PF_CODE)
ORDER BY 5 DESC,1