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