SELECT
    H.PF_CODE '都道府県コード',
    PF_NAME '都道府県',
    ROUND(INP_YES*100.0/(INP_YES+INP_NO+UNIDENTIFIED),1) '入院率'
FROM 
    HOSPITALIZATION H
    INNER JOIN PREFECTURE R ON H.PF_CODE = R.PF_CODE
ORDER BY
    入院率 DESC,
    H.PF_CODE ASC