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