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