SELECT
    P.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 H,
    PREFECTURE P
WHERE
    H.PF_CODE=P.PF_CODE
ORDER BY
    CAST( H.INP_YES AS REAL )
    / CAST( (H.INP_YES + H.INP_NO + H.UNIDENTIFIED) AS REAL )
    * 100
    DESC,
    P.PF_CODE ASC;