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