select
	 H.CLASS_NAME AS CLASS
	,H.Person_NAME AS PERSON
	,T.AMT AS HOUSEHOLDS
FROM 
	HouseHold H
INNER JOIN
(
select
	CLASS_CODE 
	,MAX(AMT) AS AMT
FROM 
	HouseHold
WHERE
	PERSON_CODE <> '1'
and
	CLASS_CODE <> '01'
GROUP BY
	CLASS_CODE
)	T
ON
	H.CLASS_CODE = T.CLASS_CODE
AND
	H.AMT = T.AMT
ORDER BY
	H.CLASS_CODE ASC
;