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