select
    class_name CLASS,
    person_name PERSON,
    amt HOUSEHOLDS
from HOUSEHOLD h1
where 1 = 1
and person_code != '1'
and class_code != '01'
and amt = (
    select max(amt) from HOUSEHOLD h2
    where 1 = 1
    and h2.person_code != '1'
    and h2.class_code != '01'
    and h1.class_code = h2.class_code
    group by h2.class_code
)
order by h1.class_code asc
;