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