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