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