select
    a.class_name as class
    ,a.person_name as person
    ,tmp.amt as households
from household a
join (
    select
        b.class_code
        ,person_name
        ,max(b.amt) as amt
    from household b
    where b.class_code <> '01'
    and b.person_code <> '1'
    
    group by b.class_code
    ) tmp
on a.class_code = tmp.class_code
where
    a.class_code <> '01'
    and a.person_code <> '1'
    and tmp.person_name = a.person_name
order by a.class_code