SELECT
    PF_CODE AS '都道府県コード',
    PF_NAME AS '都道府県名',
    (
    SELECT
        ROUND(
            CAST(INP_YES * 100 AS REAL) / CAST((INP_YES + INP_NO + UNIDENTIFIED) AS REAL)
            , 1
        )
    FROM
        HOSPITALIZATION
    WHERE
        HOSPITALIZATION.PF_CODE = PREFECTURE.PF_CODE
    ) AS '入院率'
FROM
    PREFECTURE
ORDER BY
    `入院率` DESC, PF_CODE;