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