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