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;