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