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
;