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

ORDER BY
	H.CLASS_CODE
;