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