SELECT
 h.CLASS_NAME AS CLASS
,h.PERSON_NAME AS PERSON
,MAX(h.AMT) AS HOUSEHOLDS
FROM HOUSEHOLD h
where h.PERSON_CODE <> '1'
AND h.CLASS_CODE <> '01'
group by
h.CLASS_NAME,h.PERSON_NAME
order by
1