with
  s as (
    select
      CLASS_CODE,
      ifnull(max(AMT), 0) 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,
  h.AMT as HOUSEHOLDS
from
  HOUSEHOLD h
  left join s on h.CLASS_CODE
  and h.amt = s.amt
where
  h.PERSON_CODE <> '1'
  and h.CLASS_CODE <> '01'
order by
  h.class_code