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