select
  h.PF_CODE as 都道府県コード
 ,p.pf_name as 都道府県名
 ,round(cast(INP_YES * 100 as real) / cast(INP_YES+INP_NO+UNIDENTIFIED as real),1) as  入院率
from
  HOSPITALIZATION h
  inner join
  PREFECTURE p
  on h.PF_CODE = p.PF_CODE
order by 
round(cast(INP_YES * 100 as real) / cast(INP_YES+INP_NO+UNIDENTIFIED as real),1) desc
,h.PF_CODE
;