select
a.CLASS_NAME as CLASS,
a.PERSON_NAME as PERSON,
a.AMT as HOUSEHOLDS
from HOUSEHOLD a
inner 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
and a.PERSON_CODE <> '1'
order by a.CLASS_CODE