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