select A.PF_CODE as "都道府県コード", PF_NAME as "都道府県名", B.TOTAL_AMT as "総人口2015年", C.TOTAL_AMT as "総人口2020年",
round(cast(C.TOTAL_AMT as REAL)/ cast(B.TOTAL_AMT as REAL) * 100) as "人口増加率"
FROM PREFECTURE A
LEFT JOIN POPU_TRANSITION B
on A.PF_CODE = B.PF_CODE and B.SURVEY_YEAR = 2015
LEFT JOIN POPU_TRANSITION C
on A.PF_CODE = C.PF_CODE and C.SURVEY_YEAR = 2020
where cast(C.TOTAL_AMT as REAL)/ cast(B.TOTAL_AMT as REAL) * 100 > 100
order by cast(C.TOTAL_AMT as REAL)/ cast(B.TOTAL_AMT as REAL)  desc, A.PF_CODE asc