select
    a.PF_CODE as 都道府県コード,
    PF_NAME as 都道府県名,
    round(sum(INP_YES) * 100.0 / (sum(INP_YES) + sum(INP_NO) + sum(UNIDENTIFIED)) , 2) as 入院率,
    sum(inp_yes) as yes,
    sum(inp_no) as no,
    sum(unidentified) as u
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
    round(sum(INP_YES) * 100 / (sum(INP_YES) + sum(INP_NO) + sum(UNIDENTIFIED)) , 2)  desc, 
    a.PF_CODE