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