SELECT
    CLASS_NAME AS CLASS,
    PERSON_NAME AS PERSON,
    AMT AS HOUSEHOLDS
FROM
    HOUSEHOLD
WHERE
    AMT IN (SELECT
                MAX(AMT) AS AMT
            FROM
                HOUSEHOLD
            WHERE
                PERSON_CODE <> '1' AND
                CLASS_CODE <> '01'
            GROUP BY
                CLASS_NAME)
ORDER BY
    CLASS_CODE ASC;