SELECT CAST(PT_15.PF_CODE AS INTEGER) as "都道府県コード",
PF_NAME as "都道府県名",
"総人口2015年",
"総人口2020年",
ROUND((CAST("総人口2020年" AS REAL)/CAST("総人口2015年" AS REAL))*100) as "人口増加率"
FROM (
SELECT *,
PF_CODE,TOTAL_AMT as "総人口2015年"
FROM POPU_TRANSITION
WHERE SURVEY_YEAR =2015
) as PT_15
LEFT JOIN (
SELECT PF_CODE,TOTAL_AMT as "総人口2020年"
FROM POPU_TRANSITION
WHERE SURVEY_YEAR =2020
) as PT_20 on PT_15.PF_CODE = PT_20.PF_CODE
LEFT JOIN PREFECTURE as p on PT_15.PF_CODE = p.PF_CODE
WHERE "総人口2015年" <= "総人口2020年"
ORDER BY "人口増加率" DESC,"都道府県コード" ASC