SELECT
    都道府県コード,
    都道府県名,
    入院率
FROM
    (SELECT
        p.PF_CODE AS '都道府県コード',
        p.PF_NAME AS '都道府県名',
        ROUND(CAST(INP_YES as float) / (INP_YES + INP_NO + UNIDENTIFIED) * 100, 1) AS '入院率'
    FROM
        HOSPITALIZATION AS h
    LEFT JOIN
        PREFECTURE AS p
    ON
        h.PF_CODE = p.PF_CODE
    )
ORDER BY
    入院率 DESC,
    都道府県コード
;