select
	P.PF_CODE as 都道府県コード,
	P.PF_NAME as 都道府県名,
	round(cast(H.INP_YES as real) * 100 / cast(H.INP_YES + H.INP_NO + H.UNIDENTIFIED as real),1) as 入院率
from
	HOSPITALIZATION H
inner join
	PREFECTURE P
ON
	H.PF_CODE = P.PF_CODE
ORDER BY
	入院率 desc,都道府県コード asc