WITH
    H2 AS (
        SELECT
            CLASS_NAME AS CLASS,
            PERSON_NAME AS PERSON,
            SUM(AMT) AS HOUSEHOLDS
        FROM
            HOUSEHOLD
        WHERE
            CLASS_CODE <> '01'
            AND PERSON_CODE <> '1'
        GROUP BY
            CLASS_NAME,
            PERSON_NAME
    ),
    MaxHouseholds AS (
        SELECT
            CLASS,
            MAX(HOUSEHOLDS) AS MaxHouseholds
        FROM
            H2
        GROUP BY
            CLASS
    )
SELECT
    H2.CLASS,
    H2.PERSON,
    H2.HOUSEHOLDS
FROM
    H2
    JOIN MaxHouseholds mh ON H2.CLASS = mh.CLASS
    AND H2.HOUSEHOLDS = mh.MaxHouseholds
ORDER BY
    CLASS_CODE;