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