WITH SUBCALC AS (
    SELECT
        T1.PF_CODE AS PF_CODE
      , ROUND(T1.INP_YES / CAST((T1.INP_YES + T1.INP_NO + T1.UNIDENTIFIED) AS REAL) * 100, 1) AS NYUIN
    FROM
        HOSPITALIZATION T1
)
SELECT
    T1.PF_CODE AS "都道府県コード"
  , M1.PF_NAME AS "都道府県名"
  , REPLACE(T1.NYUIN, '.0', '') AS "入院率"
FROM
    SUBCALC T1
    LEFT OUTER JOIN PREFECTURE M1
        ON T1.PF_CODE = M1.PF_CODE
ORDER BY
    T1.NYUIN DESC
  , T1.PF_CODE
;