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