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
    , 2) AS '入院率'
FROM
    PREFECTURE AS p
LEFT JOIN
    HOSPITALIZATION AS h
ON
    p.PF_CODE = h.PF_CODE
ORDER BY
    '入院率' DESC,
    '都道府県コード' ASC;