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