select p.pf_code as 都道府県コード, p.pf_name as 都道府県名, ROUND(1.0 * inp_yes / (inp_yes + inp_no + unidentified) * 100, 1) as 入院率 from prefecture p, hospitalization h
where p.pf_code = h.pf_code
order by 3 desc, 1;