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 as h
    left outer join prefecture as p 
        on h.pf_code = p.pf_code
order by 
    入院率 desc;