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