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