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