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