SELECT 
    A.PF_CODE AS 都道府県コード,
    B.PF_NAME AS 都道府県,
    MAX (CASE WHEN SURVEY_YEAR = "2015" THEN TOTAL_AMT END) as 総人口2015年,
    MAX (CASE WHEN SURVEY_YEAR = "2020" THEN TOTAL_AMT END) as 総人口2020年,
    ROUND((MAX (CASE WHEN SURVEY_YEAR = "2020" THEN CAST(TOTAL_AMT AS REAL) *100 END)/MAX (CASE WHEN SURVEY_YEAR = "2015" THEN CAST(TOTAL_AMT AS REAL)  END)),0) AS 人口増加率
FROM POPU_TRANSITION A
LEFT JOIN PREFECTURE B
ON A.PF_CODE = B.PF_CODE
GROUP BY 都道府県コード, 都道府県
HAVING  人口増加率 >= 100
ORDER BY 人口増加率 DESC, A.PF_CODE ASC