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 asc;