SELECT h.PF_CODE AS "都道府県コード", p.PF_NAME AS "都道府県名", round(cast(h.INP_YES AS REAL) / (cast(h.INP_YES AS REAL) + cast(h.INP_NO AS REAL) + cast(h.UNIDENTIFIED AS REAL)) * 100, 1) AS "入院率" FROM HOSPITALIZATION AS h JOIN PREFECTURE AS p ON h.PF_CODE = p.PF_CODE ORDER BY "入院率" DESC, h.PF_CODE