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