SELECT  PREF.PF_CODE AS 都道府県コード,
        PREF.PF_NAME AS 都道府県名,
        HOSP.INP_YES/(HOSP.INP_YES + HOSP.INP_NO + HOSP.UNIDENTIFIED)*10000+100 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;