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