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