select 
a.CLASS_NAME as CLASS
,b.PERSON_NAME as PERSON
,MAX(a.AMT) as HOUSEHOLDS
from HOUSEHOLD a
inner join HOUSEHOLD b
on a.PERSON_CODE = b.PERSON_CODE
and a.CLASS_CODE = b.CLASS_CODE
where a.PERSON_CODE <> '1'
and a.CLASS_CODE <> '01'
group by a.CLASS_NAME
order by a.CLASS_CODE asc