SELECT
    CLASS_NAME AS CLASS
    , PERSON_NAME AS PERSON
    , AMT AS HOUSEHOLDS
FROM HOUSEHOLD
WHERE AMT IN(
    SELECT
        MAX(AMT)
    FROM HOUSEHOLD
    WHERE NOT(
        PERSON_CODE = '1'
       OR CLASS_CODE = '01'
    )
        GROUP BY CLASS_NAME)
ORDER BY CLASS_CODE ASC