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