WITH
    H1 AS (
        SELECT
            CLASS_CODE,
            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
    )
SELECT
    CLASS,
    PERSON,
    HOUSEHOLDS
FROM
    H1
WHERE
    HOUSEHOLDS = (
        SELECT
            MAX(HOUSEHOLDS)
        FROM
            H1 AS H1_tmp
        WHERE
            H1.CLASS = H1_tmp.CLASS
    )
ORDER BY
    CLASS_CODE;