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