select 
    p.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
    inner join prefecture p on h.pf_code = p.pf_code
order by
    入院率 desc
    , 都道府県コード asc