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