select
	CLASS_NAME as CLASS,
	PERSON_NAME as PERSON,
	MAX(AMT) as HOUSEHOLDS
	from HOUSEHOLD
where PERSON_CODE <> '1'
	and CLASS_CODE <> '01'
group by CLASS_NAME--,PERSON_NAME
order by CLASS_CODE
;