SELECT HOS.PF_CODE AS 都道府県コード
      ,PRE.PF_NAME AS 都道府県名
      ,ROUND(
             CAST(HOS.INP_YES AS REAL)
             /
             CAST((HOS.INP_YES + HOS.INP_NO + HOS.UNIDENTIFIED) AS REAL)
             * 100
             ,1) 
              AS 入院率
FROM  HOSPITALIZATION HOS
INNER JOIN PREFECTURE PRE
ON  HOS.PF_CODE = PRE.PF_CODE
ORDER BY 入院率 DESC
        ,HOS.PF_CODE