select  H3.CLASS_NAME CLASS
        ,H3.PERSON_NAME PERSON
        ,H3.AMT HOUSEHOLDS
  from  HOUSEHOLD H3,
(select  H1.CLASS_NAME 
        ,MAX(H1.AMT) AMTW
  from  HOUSEHOLD H1
 where  H1.PERSON_CODE <> '1'
    and H1.CLASS_CODE <> '01'
 group by H1.CLASS_NAME
 )H2
 where  H3.CLASS_NAME = H2.CLASS_NAME
   and  H3.AMT = H2.AMTW
   and  H3.PERSON_CODE <> '1'
   and H3.CLASS_CODE <> '01'
 order by CLASS_CODE