SELECT CLASS_NAME as CLASS, PERSON_NAME as PERSON, MAX(AMT) as HOUSEHOLDS
FROM HOUSEHOLD
GROUP BY CLASS_NAME, PERSON_NAME
HAVING PERSON_CODE <> 1 and CLASS_CODE <> "01"
ORDER BY CLASS_CODE