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