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