select h.PF_CODE 都道府県コード,
    p.pf_name 都道府県名,
    round( (cast(inp_yes as real)/cast(inp_yes + inp_no + unidentified as real))*100, 1) 入院率  
from hospitalization h
inner join prefecture p
on p.pf_code = h.pf_code
group by p.pf_code
order by 入院率 desc;