select Y15.PF_CODE as "都道府県コード", P.PF_NAME as "都道府県名", Y15.TOTAL_AMT "総人口2015年", Y20.TOTAL_AMT "総人口2020年", round(100 * cast(Y20.TOTAL_AMT as float) / cast(Y15.TOTAL_AMT as float)) as "人口増加率" from POPU_TRANSITION Y15 inner join POPU_TRANSITION Y20 on Y15.PF_CODE = Y20.PF_CODE inner join PREFECTURE P on Y15.PF_CODE=P.PF_CODE where Y15.SURVEY_YEAR=2015 and Y20.SURVEY_YEAR=2020 and Y15.TOTAL_AMT < Y20.TOTAL_AMT order by "人口増加率" desc, Y15.PF_CODE