select CLASS_NAME as CLASS, PERSON_NAME as PERSON, max(AMT) as HOUSEHOLDS
from HOUSEHOLD
where PERSON_CODE <> '1' and CLASS_CODE <> '01' and PERSON_CODE is not null and CLASS_CODE is not null
group by CLASS_CODE
order by CLASS_CODE asc