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