WITH C AS (
    SELECT
        P.PF_CODE,
        P.PF_NAME,
        CAST(INP_YES AS REAL) / (INP_YES + INP_NO + UNIDENTIFIED) * 100 AS RATE
    FROM
        HOSPITALIZATION H 
        INNER JOIN PREFECTURE P
            ON H.PF_CODE = P.PF_CODE
)
SELECT
    PF_CODE AS [都道府県コード],
    PF_NAME AS [都道府県名],
    ROUND(RATE, 2) AS [入院率]
FROM
    C
ORDER BY
    RATE DESC