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
    ,都道府県コード asc