select  a.PF_CODE as 都道府県コード,
        b.PF_NAME as 都道府県名,
        round (cast(a.INP_YES as real)
        /CAST((a.INP_YES+a.INP_NO+a.UNIDENTIFIED) as real) *100,1 )as 入院率
from HOSPITALIZATION as a
        left join PREFECTURE as b on a.PF_CODE = b.PF_CODE
ORDER BY
    入院率 DESC
    , a.PF_CODE ASC;