select distinct CLASS_NAME as CLASS, PERSON_NAME as PERSON, max(AMT) as HOUSEHOLDS
 from HOUSEHOLD where not PERSON_CODE = '1' and not CLASS_CODE = '01'
  group by CLASS_CODE order by CLASS_CODE asc;