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