select
    PF_CODE as '都道府県コード'
    ,PF_NAME as '都道府県名'
    ,RATE as '入院率'
from (
    select
        P.PF_CODE
        ,P.PF_NAME
        ,round(
            100.0 * cast(INP_YES as real) / cast((INP_YES + INP_NO + UNIDENTIFIED) as real)
            ,1) -- 2位を四捨五入ー＞1
            as RATE
    from
        PREFECTURE P -- 都道府県リスト
        left outer join
            HOSPITALIZATION H 
            on
                P.PF_CODE=H.PF_CODE
) foo

order by 3 desc, 1
;