select
    h.pf_code as 都道府県コード,
    p.pf_name as 都道府県名,
    round((cast(h.inp_yes as double) / cast((h.inp_yes + h.inp_no + h.unidentified) as double)) * 100,1) as 入院率
from
    hospitalization h
    inner join
        prefecture p
    on h.pf_code = p.pf_code
order by
    入院率 desc,
    p.pf_code asc
;