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