select
CLASS_NAME as CLASS
,PERSON_NAME as PERSON
,max(AMT) as HOUSEHOLDS
from
HOUSEHOLD
where 
PERSON_CODE != 1
and
CLASS_CODE != '01'
group by
CLASS_NAME;