select
    H.PF_CODE as 都道府県コード,
    P.PF_NAME as 都道府県名,
    ROUND(
        CAST(H.INP_YES as real) /
        cast(H.INP_YES + H.INP_NO + UNIDENTIFIED as real)
        * 100, 1) as 入院率
FROM HOSPITALIZATION H
JOIN PREFECTURE P
on H.PF_CODE = P.PF_CODE
ORDER by 入院率 desc, 都道府県コード asc