WITH tbl1 AS (
    SELECT
        PF_CODE,
        ROUND(100 * CAST(INP_YES AS real) / CAST((INP_YES+INP_NO+UNIDENTIFIED) AS  real),1) AS rate
    FROM    
        HOSPITALIZATION
)
SELECT
    PREFECTURE.PF_CODE AS '都道府県コード',
    PF_NAME AS '都道府県名',
    rate AS '入院率' -- 都道府県毎の入院率
FROM
    tbl1
LEFT JOIN
    PREFECTURE
    ON tbl1.PF_CODE = PREFECTURE.PF_CODE
ORDER BY
    rate DESC, PREFECTURE.PF_CODE