with
  s as (
    select
      CLASS_CODE,
      max(AMT) amt
    from
      HOUSEHOLD
    where
      PERSON_CODE <> '1'
      and CLASS_CODE <> '01'
    group by
      CLASS_CODE
  )
select
  h.CLASS_NAME as CLASS,
  h.PERSON_NAME as PERSON,
  max(h.AMT) as HOUSEHOLDS
from
  HOUSEHOLD h
  join s on h.CLASS_CODE
  and h.amt = s.amt
where
  h.PERSON_CODE <> '1'
  and h.CLASS_CODE <> '01'
group by h.class_code,h.PERSON_NAME 
order by h.class_code