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