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