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, PERSON_NAME
ORDER BY CLASS_CODE ASC
;