WITH CLASS_PERSON_GRP AS (
    SELECT
        H.CLASS_NAME
        ,H.PERSON_NAME
        ,SUM(H.AMT) AS AMT
    FROM
        HOUSEHOLD AS H
    WHERE
        H.PERSON_CODE != '1'
        AND
        H.CLASS_CODE != '01'
    GROUP BY
        H.PERSON_NAME
        ,H.CLASS_NAME
    ORDER BY
        H.CLASS_CODE
)
, MAX_AMT AS (
    SELECT
        CLASS_NAME
        ,MAX(AMT) AS MAX_AMT
    FROM
        CLASS_PERSON_GRP
    GROUP BY
        CLASS_NAME
    )
SELECT
    CP.CLASS_NAME AS 'CLASS'
    ,CP.PERSON_NAME AS 'PERSON'
    ,CP.AMT AS 'HOUSEHOLDS'
FROM
    CLASS_PERSON_GRP AS CP
LEFT JOIN
    MAX_AMT AS MA
ON
    CP.CLASS_NAME = MA.CLASS_NAME
WHERE
    MA.MAX_AMT = CP.AMT