SELECT CLASS_NAME CLASS,
    PERSON_NAME PERSON,
    AMT HOUSEHOLDS

FROM HOUSEHOLD H1

WHERE PERSON_CODE != 1 AND CLASS_CODE != '01'
AND NOT EXISTS (
    SELECT 1 
    FROM HOUSEHOLD H2
    WHERE H2.CLASS_CODE = H1.CLASS_CODE
    AND PERSON_CODE != 1
    AND H2.AMT > H1.AMT
)

ORDER BY CLASS_CODE