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