select 
    CLASS_NAME as CLASS,
    max(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