select
	CLASS_NAME as CLASS
	,PERSON_NAME as PERSON
	,AMT as HOUSEHOLDS
from 
	HOUSEHOLD t1
inner join(
	select
		CLASS_CODE
		,max(AMT) as max_amt
	from 
		HOUSEHOLD
	where 
		PERSON_CODE <> '1'
		and CLASS_CODE <> '01'
	group by
		CLASS_CODE
	) t2
	on t1.CLASS_CODE = t2.CLASS_CODE
	and t1.AMT = t2.max_amt
order by
	t1.CLASS_CODE