select
    class_name CLASS,
    person_name PERSON,
    max(amt) HOUSEHOLDS
from
    household
where
    person_code != '1' and class_code != '01'
group by
    class_code
order by
    class_code;