select
  H.PF_CODE as 都道府県コード, 
  P.PF_NAME as 都道府県名, 
  CASE 
    WHEN 
      mod(round(INP_YES*1.0/(INP_YES+INP_NO+UNIDENTIFIED)*100 , 1), 1) = 0
    THEN 
      round(INP_YES*1.0/(INP_YES+INP_NO+UNIDENTIFIED)*100 , 0) 
    ELSE 
      round(INP_YES*1.0/(INP_YES+INP_NO+UNIDENTIFIED)*100 , 1) 
  END as 入院率
from
  HOSPITALIZATION H
JOIN
  PREFECTURE P
ON
  H.PF_CODE = P.PF_CODE
ORDER BY
  3 DESC, 1;