select
    a.PF_CODE as 都道府県コード,
    PF_NAME as 都道府県名,
    cast(sum(INP_YES) * 100 / (sum(INP_YES) + sum(INP_NO) + sum(UNIDENTIFIED)) as int) as 入院率
from 
    HOSPITALIZATION as a
    inner join PREFECTURE as b
    on a.PF_CODE = b.PF_CODE
group by
    a.PF_CODE,
    PF_NAME
order by
    cast(sum(INP_YES) * 100 / (sum(INP_YES) + sum(INP_NO) + sum(UNIDENTIFIED)) as int) desc,
    a.PF_CODE