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