SELECT
    T1.PF_CODE AS "都道府県コード"
    , T1.PF_NAME AS "都道府県名"
    , CASE 
        WHEN T2.PF_CODE IS NULL 
            THEN 0 
        ELSE ROUND( 
            CAST(T2.INP_YES AS DOUBLE) / (T2.INP_YES + T2.INP_NO + T2.UNIDENTIFIED) * 100
            , 1
        ) 
        END AS "入院率" 
FROM
    PREFECTURE AS T1 
    LEFT OUTER JOIN HOSPITALIZATION AS T2 
        ON T1.PF_CODE = T2.PF_CODE 
ORDER BY
    "入院率" DESC;