SELECT PR.PF_CODE AS 都道府県コード,PR.PF_NAME AS 都道府県名,ROUND(100.0 * HO.INP_YES / (HO.INP_YES + HO.INP_NO + HO.UNIDENTIFIED),1) AS 入院率 FROM PREFECTURE AS PR INNER JOIN HOSPITALIZATION AS HO ON PR.PF_CODE = HO.PF_CODE ORDER BY 入院率 DESC,PR.PF_CODE ASC;