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