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.PERSON_CODE <> '1'
            AND h2.CLASS_CODE <> '01'
            AND h2.CLASS_CODE = h1.CLASS_CODE
        GROUP BY
            h2.CLASS_CODE
    )
GROUP BY
    h1.CLASS_CODE;