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