SELECT 
	temp.PF_CODE as '都道府県コード'
	,p.PF_NAME as '都道府県名'
	,ROUND(((1.0*temp.yes)/(temp.yes+temp.no+temp.un))*100,1) as '入院率'
FROM(
	SELECT
		PF_CODE
		,SUM(INP_YES) as yes
		,SUM(INP_NO) as no 
		,SUM(UNIDENTIFIED) as un
	FROM 
		HOSPITALIZATION
	GROUP BY
		PF_CODE 
) as temp
INNER JOIN
	PREFECTURE as p
ON temp.PF_CODE = p.PF_CODE
ORDER BY 
	ROUND(((1.0*temp.yes)/(temp.yes+temp.no+temp.un))*100,1) desc
	,temp.PF_CODE
;