select
  t1.CLASS_NAME CLASS,
  t1.PERSON_NAME PERSON,
  t1.AMT HOUSEHOLDS
from
  HOUSEHOLD t1
  inner join (select CLASS_NAME, MAX(AMT) MAX_AMT from HOUSEHOLD where PERSON_CODE <> '1' and CLASS_CODE <> '01' group by CLASS_NAME) t2
    on t1.CLASS_NAME = t2.CLASS_NAME
    and t1.AMT = t2.MAX_AMT
where
  t1.PERSON_CODE <> '1'
  and t1.CLASS_CODE <> '01'
order by
  t1.CLASS_CODE
;