SELECT
    PF_CODE AS 都道府県コード
    , PF_NAME AS 都道府県名
    , 入院率
FROM
    (
        SELECT
            PF_CODE
            , ROUND((CAST(INP_YES AS REAL) / (INP_YES + INP_NO + UNIDENTIFIED)) * 100, 1) AS 入院率
        FROM
            HOSPITALIZATION
    ) HX
    INNER JOIN PREFECTURE
    USING (PF_CODE)
ORDER BY
    入院率 DESC
    , PF_CODE