SELECT
	h1.CLASS_NAME AS CLASS
	,h1.PERSON_NAME AS PERSON
	,h2.AMT AS HOUSEHOLDS
FROM
	HOUSEHOLD AS h1
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
	h1.CLASS_CODE = h2.CLASS_CODE
	AND h1.AMT = h2.AMT
ORDER BY
	h1.CLASS_CODE
;