SELECT
CLASS_NAME AS CLASS
,PERSON_NAME AS PERSON
,AMT AS "HOUSEHOLDS"
FROM
HOUSEHOLD AS h1
WHERE AMT = 
(SELECT MAX(AMT) FROM HOUSEHOLD AS h2
    WHERE h2.PERSON_CODE <> '1' AND h2.CLASS_CODE <> '01'
    AND h1.CLASS_CODE = h2.CLASS_CODE
)
ORDER BY CLASS_CODE;