select 
CLASS_NAME CLASS,max(PERSON_NAME) PERSON,max(AMT) HOUSEHOLDS
from 
HOUSEHOLD
where PERSON_CODE<>'1'
and
CLASS_CODE<>'01'
group by 1
order by CLASS_CODE
;