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_NAME
order by CLASS_CODE ASC