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