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