select a.CLASS_NAME        AS CLASS
      ,b.PERSON_NAME       AS PERSON
      ,a.max_AMT           AS HOUSEHOLDS
from
   (
   select CLASS_CODE
         ,CLASS_NAME
         ,max(PERSON_CODE)  max_PERSON_CODE
         ,max(AMT)          max_AMT
   from   HOUSEHOLD
   where
          PERSON_CODE||CLASS_CODE <> '101'
   group by CLASS_CODE,CLASS_NAME
   ) a
  ,(select PERSON_CODE,PERSON_NAME from HOUSEHOLD group by PERSON_CODE,PERSON_NAME) b
where
  a.max_PERSON_CODE = b.PERSON_CODE
order by a.CLASS_CODE