SELECT
    W.PF_CODE AS '都道府県コード',
    W.PF_NAME AS '都道府県名',
    W.INP_RATE AS '入院率'
FROM (
    SELECT
        CAST(P.PF_CODE AS INTEGER) AS PF_CODE,
        P.PF_NAME,
        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 INP_RATE
    FROM
        PREFECTURE AS P
        INNER JOIN HOSPITALIZATION AS H
ON P.PF_CODE = H.PF_CODE
) AS W
ORDER BY
    INP_RATE DESC,
    PF_CODE ASC