SELECT HO.PF_CODE 都道府県コード
       ,PF_NAME AS 都道府県名
       ,ROUND(INP_YES/(INP_YES+INP_NO+UNIDENTIFIED)*100, 1) 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,都道府県コード