SELECT
    A.CLASS_NAME AS CLASS
,   A.PERSON_NAME AS PERSON
,   A.AMT AS HOUSEHOLDS
FROM
    HOUSEHOLD A
INNER JOIN
    (
    SELECT
        A.CLASS_CODE
    ,   MAX(A.AMT) AS MAX_AMT
    FROM
        HOUSEHOLD A
    WHERE
        A.PERSON_CODE <> '1'
    AND A.CLASS_CODE <> '01'
    GROUP BY
        A.CLASS_CODE
    ) B
ON
    A.CLASS_CODE = B.CLASS_CODE
AND A.AMT = B.MAX_AMT
ORDER BY
    A.CLASS_CODE
;