select
    HP.PF_CODE as 都道府県コード,
    PF.PF_NAME as 都道府県名,
    round( 
        cast(HP.INP_YES as REAL) / 
        cast( (HP.INP_YES + HP.INP_NO + HP.UNIDENTIFIED) as REAL)
        * 100
        , 1
    ) as 入院率
from
    HOSPITALIZATION as HP
    left join 
    PREFECTURE as PF
    ON PF.PF_CODE = HP.PF_CODE 
order by
    入院率 desc
    , HP.PF_CODE ASC;