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