select 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_NAME order by CLASS_CODE asc;