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 
    入院率 desc
    ,都道府県コード asc