select
class_name as CLASS
,PERSON_NAME as PERSON
,AMT as HOUSEHOLDS
from household as h
inner join 
(
    select
    class_code
    ,max(amt) as total_max
    from household 
    where person_code <> '1'
    and class_code <>'01'
    group by class_code
) as mh
on h.class_code = mh.class_code
and h.amt = mh.total_max
order by h.class_code asc