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