select CLASS_NAME as CLASS,
PERSON_NAME as PERSON,
max(AMT) as HOUSEHOLDS
from HOUSEHOLD
where not (PERSON_CODE=="1" or CLASS_CODE=="01")
group by CLASS;