select
	CLASS_NAME as CLASS
	,PERSON_NAME as PERSON
	,AMT as HOUSEHOLDS
from
	HOUSEHOLD
where
	PERSON_CODE <> '1'
and CLASS_CODE <> '01'
and AMT is not null
group by
	CLASS_CODE
having
	AMT = max(AMT)
order by
	CLASS_CODE