select 
  h2.CLASS_NAME as CLASS
  ,h2.PERSON_NAME as PERSON
  ,h2.AMT as HOUSEHOLDS
from 
  HOUSEHOLD h2
  ,(select 
     h1.CLASS_CODE
     ,max(h1.AMT) amt
   from 
     HOUSEHOLD h1
   where 
     h1.PERSON_CODE <> '1'
   and h1.CLASS_CODE <> '01'
  group by 
    h1.CLASS_CODE
  ) h3
where 
  h2.CLASS_CODE = h3.CLASS_CODE
  and h2.amt = h3.amt
order by 
  h2.CLASS_CODE asc