select
    hp.PF_CODE as 都道府県コード
    , pf.PF_NAME as 都道府県名
    , ROUND(
        (CAST(hp.INP_YES as float) / CAST(hp.INP_YES + hp.INP_NO + hp.UNIDENTIFIED as float)) * 100
        ,
        1) as 入院率
from
    HOSPITALIZATION as hp
    left join PREFECTURE as pf
    on hp.PF_CODE = pf.PF_CODE 
order by
    入院率 desc
    , hp.PF_CODE ASC
;