select H.PF_CODE as 都道府県コード
      ,PF_NAME  as 都道府県名
      ,ROUND((CAST(H.INP_YES AS REAL) / CAST(H.INP_YES + H.INP_NO + H.UNIDENTIFIED AS REAL)) * 100, 1) as 入院率
  from HOSPITALIZATION H
 inner join PREFECTURE P
    on H.PF_CODE = P.PF_CODE
 order by 入院率 desc, 都道府県コード
;