SELECT
	CLASS
	, PERSON
	, HOUSEHOLDS
FROM
(
	SELECT
		ROW_NUMBER() OVER (PARTITION BY CLASS_CODE ORDER BY AMT DESC) AS ROWNUM
		, CLASS_CODE
		, CLASS_NAME AS CLASS
		, PERSON_NAME AS PERSON
		, AMT AS HOUSEHOLDS
	FROM
		HOUSEHOLD
	WHERE
	    NOT (PERSON_CODE = '1'
		OR CLASS_CODE = '01')
		
) T
WHERE
	ROWNUM = 1
ORDER BY
	CLASS_CODE