select
            CLASS_NAME CLASS
            ,PERSON_NAME PERSON
            ,MAX(AMT) HOUSEHOLDS
        FROM 
            HouseHold
        WHERE
            PERSON_CODE <> '1'
        and
            CLASS_CODE <> '01'
        GROUP BY
            CLASS_CODE
        ORDER BY
            CLASS_CODE ASC
        ;