select
    CLASS_NAME as CLASS,
    PERSON_NAME as PERSON,
    MAX(AMT) as HOUSEHOLDS
from
    HOUSEHOLD as H1
where
    PERSON_CODE <> '1'
    AND CLASS_CODE <> '01'
group by
    CLASS_CODE
order by
    CLASS_CODE asc