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.0, 1) as 入院率
from
  HOSPITALIZATION h
left outer join
  PREFECTURE p on h.PF_CODE = p.PF_CODE
order by 入院率 desc, 都道府県コード asc;