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