SELECT
h.CLASS_NAME AS CLASS, h.PERSON_NAME AS PERSON, MAX(h.AMT) AS HOUSEHOLDS
FROM
HOUSEHOLD h
WHERE PERSON_CODE != '1' AND CLASS_CODE != '01'
GROUP BY CLASS_NAME