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)
ORDER BY
	CLASS_CODE
;