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