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 h
inner join PREFECTURE p on h.PF_CODE = p.PF_CODE
order by 入院率 desc, 都道府県コード;