select
    CLASS_NAME as CLASS,
    MAX(PERSON_NAME,1,1) as PERSON,
    MAX(AMT) as HOUSEHOLDS
from
    HOUSEHOLD
where
    PERSON_CODE != '1' and
    CLASS_CODE != '01'
group by
    CLASS_CODE
order by
    CLASS_CODE
;