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