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