SELECT
	CLASS
	, PERSON
	, HOUSEHOLDS
FROM
(
	SELECT
		RANK() 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
	    PERSON_CODE <> '1'
		AND CLASS_CODE <> '01'
		
) T
WHERE
	ROWNUM = 1
ORDER BY
	CLASS_CODE