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