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