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