select h.PF_CODE as "都道府県コード", PF_NAME as "都道府県名", round(100.0 * INP_YES / (INP_YES + INP_NO + UNIDENTIFIED), 1) as "入院率" from HOSPITALIZATION as h join PREFECTURE as p on h.PF_CODE = p.PF_CODE order by "入院率" desc, h.PF_CODE desc;