select
    PF_CODE as '都道府県コード'
    ,PF_NAME as '都道府県名'
    ,case 
        when RATE like '%.0' then round(RATE)
        else RATE
        end as '入院率'
from (
    select
        P.PF_CODE
        ,P.PF_NAME
        ,round(
            100.0 * INP_YES / 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
    order by 3 desc, 1
) foo
;