select p.pf_name '都道府県名',
round(cast(inp_yes as REAL) / cast((inp_yes + inp_no + unidentified) as REAL) * 100, 1) '入院率'
from hospitalization h
join prefecture p using(pf_code)
order by 入院率 desc;