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