select a.CLASS_NAME  CLASS
      ,b.PERSON_NAME PERSON
      ,a.max_amt     HOUSEHOLDS
from
 (select CLASS_CODE,CLASS_NAME,max(AMT) max_amt from HOUSEHOLD
  where  PERSON_CODE <> '1' and CLASS_CODE <> '01'
  group by CLASS_CODE,CLASS_NAME) a
,HOUSEHOLD b
where
    a.CLASS_CODE = b.CLASS_CODE
and a.max_amt    = b.amt
order by a.CLASS_CODE