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