select HP.PF_CODE 都道府県コード, PF.PF_NAME 都道府県名, ROUND(cast(HP.INP_YES as real)*100/cast((HP.INP_YES+INP_NO+UNIDENTIFIED) as real), 1) 入院率
from HOSPITALIZATION as HP
    INNER JOIN PREFECTURE as PF
    ON HP.PF_CODE = PF.PF_CODE
order by ROUND(cast(HP.INP_YES as real)*100/cast((HP.INP_YES+INP_NO+UNIDENTIFIED) as real), 1) DESC,  HP.PF_CODE DESC;