select h.pf_code AS '都道府県コード', p.pf_name AS '都道府県名', round(100.0 * h.inp_yes / (h.inp_yes + h.inp_no + h.unidentified), 1) AS '入院率' from hospitalization as h join prefecture as p on h.pf_code = p.pf_code ORDER BY round(100.0 * h.inp_yes / (h.inp_yes + h.inp_no + h.unidentified),1) desc, h.pf_code;