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