select 
a.person_name as PERSON
,a.amt as HOUSEHOLDS
,a.class_name as CLASS
from household a
where a.person_code <> '1'
and a.class_code <> '01'
and a.amt = (
    select max(b.amt) as amt
    from household b
    where b.person_code <> '1'
    and b.class_code <> '01'
    and a.class_code = b.class_code
)
order by a.class_code