SELECT
H1.CLASS_NAME AS CLASS,
H1.PERSON_NAME AS PERSON,
H1.AMT AS HOUSEHOLDS

FROM
HOUSEHOLD AS H1

WHERE
H1.CLASS_CODE <> '01'
AND H1.PERSON_CODE <> '1'
AND H1.AMT = (
SELECT 
MAX(H2.AMT)
FROM 
HOUSEHOLD AS H2
WHERE 
H2.CLASS_CODE = H1.CLASS_CODE
AND H2.CLASS_CODE <> '01'
AND H2.PERSON_CODE <> '1'
GROUP BY
H2.CLASS_CODE
)



ORDER BY CLASS_CODE ASC;