SELECT
	HOSPITALIZATION.PF_CODE AS [都道府県コード]
	,PREFECTURE.PF_NAME AS [都道府県名]
	,REPLACE(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), '.00', '') AS [入院率]
FROM HOSPITALIZATION
INNER JOIN PREFECTURE
ON PREFECTURE.PF_CODE = HOSPITALIZATION.PF_CODE
GROUP BY
	HOSPITALIZATION.PF_CODE
	,PREFECTURE.PF_NAME
ORDER BY
    REPLACE(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), '.00', '') DESC
;