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