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