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