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