select
	h.PF_CODE as 都道府県コード
	,p.PF_NAME as 都道府県名
	,round(cast(h.INP_YES as real) * 100 / (h.INP_YES + h.INP_NO + h.UNIDENTIFIED),1) as 入院率
from
	HOSPITALIZATION as h
	inner join PREFECTURE as p
		on h.PF_CODE = p.PF_CODE
order by
	3 desc
	,1