select a.CLASS_NAME as CLASS , a.PERSON_NAME as PERSON , 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
order by a.CLASS_CODE