SELECT
	HOS.PF_CODE as '都道府県コード'
	,PR.PF_NAME as '都道府県名'
	,ROUND(
		CAST(HOS.INP_YES as REAL) 
		* 100 
		/ CAST(HOS.INP_YES + HOS.INP_NO + HOS.UNIDENTIFIED as REAL)
		,1) as '入院率'
FROM
	HOSPITALIZATION as HOS
	,PREFECTURE as PR
WHERE
	HOS.PF_CODE = PR.PF_CODE
ORDER BY
	入院率 DESC
	,HOS.PF_CODE