select 
 w.CLASS
,MAX(w.PERSON)
,MAX(w.HOUSEHOLDS)
FROM(
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
) w
GROUP BY w.CLASS
order by
1