SELECT
    A.PF_CODE as 都道府県コード,
    B.PF_NAME as 都道府県名,
    ROUND(
        100 * 1.0 * A.INP_YES / (A.INP_YES + A.INP_NO + A.UNIDENTIFIED),
        1
    ) as 入院率
FROM
    HOSPITALIZATION as A
INNER JOIN
    PREFECTURE as B
WHERE
    A.PF_CODE = B.PF_CODE
ORDER BY
    入院率 DESC,
    都道府県コード ASC
;