select 
    H.PF_CODE as 都道府県コード,
    P.PF_NAME as 都道府県名,
    round(
        100*
        cast(INP_YES as real)
        /
        cast((INP_YES+INP_NO+UNIDENTIFIED) as real)
        ,1
        ) as 入院率
from 
    HOSPITALIZATION as H
inner join
    PREFECTURE as P
    on H.PF_CODE=P.PF_CODE
order by
    '入院率' desc,
    H.PF_CODE asc