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