select 
  p.pf_code as '都道府県コード',
  p.pf_name as '都道府県名',
  round((cast(h.inp_yes as real) / (cast(h.inp_yes as real) + cast(h.inp_no as real) + cast(h.UNIDENTIFIED as real))) * 100, 1) as '入院率'
from HOSPITALIZATION h
join PREFECTURE p on h.pf_code = p.pf_code
order by 3 desc, 1 asc;