select
    h.PF_CODE as 都道府県コード,
    p.PF_NAME as 都道府県名,
    round(
        cast(h.INP_YES as real) /
        cast((h.INP_YES+h.INP_NO+h.UNIDENTIFIED) as real)
        * 100
        , 1
    ) as 入院率
from HOSPITALIZATION as h inner join PREFECTURE as p
on h.PF_CODE = p.PF_CODE
order by 入院率 desc, 
        都道府県コード asc;