select
    CLASS_NAME as CLASS
    , PERSON_NAME as PERSON
    , max(AMT) as HOUSEHOLDS
from
    HOUSEHOLD
where
    not ( PERSON_CODE = '1' or CLASS_CODE = '01')
group by
    CLASS_CODE
order by
    CLASS_CODE asc