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 h
left join 
    PREFECTURE p
on h.PF_CODE = p.PF_CODE

order by 
    '入院率' desc,
    '都道府県コード' asc