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
    INNER JOIN
    PREFECTURE as p
    ON h.pf_code = p.pf_code
order by
    入院率 DESC