SELECT 
	a.PF_CODE as 都道府県コード,
	b.PF_NAME as 都道府県名,
	rtrim(rtrim(
		round(a.INP_YES * 100.0 / (a.INP_YES + a.INP_NO + a.UNIDENTIFIED), 1)
	, '0'), '.') as 入院率
FROM
	HOSPITALIZATION a,
	PREFECTURE b
WHERE
	a.PF_CODE = b.PF_CODE
ORDER BY
	入院率 DESC,
	都道府県コード ASC