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
	, H.PF_CODE ASC;