select class_name as CLASS, person_name as PERSON, max(amt) as HOUSEHOLDS
from HOUSEHOLD
where person_code != '1' and class_code != '01' and amt is not null
group by class_code
order by class_code asc;