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