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