select
  p.PF_CODE as '都道府県コード',
  p.PF_NAME as '都道府県名',
  round(100 * cast(INP_YES as REAL) / cast((INP_YES + INP_NO + UNIDENTIFIED) as REAL), 1) as '入院率'
from
  PREFECTURE p
left join
  HOSPITALIZATION h
on
  p.PF_CODE = h.PF_CODE
where
  `入院率` is not null
order by
  `入院率` desc,
  `都道府県コード`
;