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