select 
class_name as class
,person_name as person
,amt as household
from household a
where 
person_code <> '1' and class_code <> '01'
and 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