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