SELECT
	A.CLASS_NAME AS CLASS
	,A.PERSON_NAME AS PERSON
	,A.AMT AS HOUSEHOLDS
FROM
	HOUSEHOLD A
INNER JOIN (
	SELECT CLASS_CODE,MAX(AMT) AMT
	FROM HOUSEHOLD
	WHERE PERSON_CODE <>1
	AND CLASS_CODE <>'01'
	GROUP BY CLASS_CODE
) B
ON A.CLASS_CODE=B.CLASS_CODE AND A.AMT =B.AMT