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