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