select
    h.class_name CLASS
    , h.PERSON_NAME PERSON
    , max(amt) HOUSEHOLDS
from HOUSEHOLD h 
where 
    h.PERSON_CODE != '1' and h.CLASS_CODE != '01'
group by 
    h.class_name
order by h.class_code