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