SELECT
	CLASS_NAME AS CLASS
	,PERSON_NAME AS PERSON
	,AMT AS HOUSEHOLDS
FROM
	HOUSEHOLD
WHERE
	PERSON_CODE != '1'
	AND CLASS_CODE != '01'
	AND AMT IN (SELECT MAX(AMT) FROM HOUSEHOLD WHERE PERSON_CODE != '1' AND CLASS_CODE != '01' GROUP BY CLASS_NAME)
GROUP BY
	CLASS_NAME
ORDER BY
	CLASS_CODE
;