SELECT CAST(HO.PF_CODE AS INTEGER) AS 都道府県コード
       ,PF_NAME AS 都道府県名
       ,CASE
        WHEN ROUND(INP_YES/(INP_YES+INP_NO+UNIDENTIFIED)*100, 1)
              = ROUND(CAST(INP_YES/(INP_YES+INP_NO+UNIDENTIFIED)*100 AS INTEGER), 1) 
        THEN ROUND(CAST(INP_YES/(INP_YES+INP_NO+UNIDENTIFIED)*100 AS INTEGER),1)--整数
        WHEN ROUND(INP_YES/(INP_YES+INP_NO+UNIDENTIFIED)*100, 1)
              <> ROUND(CAST(INP_YES/(INP_YES+INP_NO+UNIDENTIFIED)*100 AS INTEGER), 1)
        THEN ROUND(INP_YES/(INP_YES+INP_NO+UNIDENTIFIED)*100, 1)--少数
        END AS 入院率 --入院者あり/（入院者あり＋入院者なし+不詳）*100
  FROM (SELECT PF_CODE
               ,CAST(INP_YES AS REAL) INP_YES
               ,CAST(INP_NO AS REAL) INP_NO
               ,CAST(UNIDENTIFIED AS REAL) UNIDENTIFIED
          FROM HOSPITALIZATION) AS HO
  LEFT JOIN PREFECTURE AS PR
    ON HO.PF_CODE = PR.PF_CODE
 ORDER BY 入院率 DESC,都道府県コード