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