SELECT
    PF_CODE AS '都道府県コード',
    (
    SELECT
        PF_NAME
    FROM
        PREFECTURE
    WHERE
        HOSPITALIZATION.PF_CODE == PREFECTURE.PF_CODE
    )
    AS
        '都道府県名',
    INP_YES * 100 / (INP_YES + INP_NO + UNIDENTIFIED)

    AS
        '入院率'
FROM
    HOSPITALIZATION;