select t1.CLASS_NAME as CLASS
,t1.PERSON_NAME as PERSON
,t1.AMT as HOUSEHOLDS
from HOUSEHOLD t1
join(
	select CLASS_NAME,MAX(AMT)as AMT
	from HOUSEHOLD
	where PERSON_CODE not in ('1')
    and CLASS_CODE not in ('01')
	group by CLASS_NAME)as t2
on t1.CLASS_NAME=t2.CLASS_NAME
and t1.AMT =t2.AMT