select
    h.pf_code "都道府県コード",
    p.pf_name "都道府県名",
    round(100 * h.inp_yes / cast(h.inp_yes + h.inp_no + h.unidentified as real), 1) "入院率"

from
    hospitalization h
left outer join
    prefecture p
on h.pf_code = p.pf_code
order by "入院率" desc,  "都道府県コード" asc