SELECT
  t1.CLASS_NAME AS CLASS,
  t2.PERSON_NAME AS PERSON,
  t1.AMT AS HOUSEHOLDS
FROM
  (SELECT
     CLASS_CODE,
     CLASS_NAME,
     PERSON_CODE,
     PERSON_NAME,
     AMT,
     ROW_NUMBER() OVER (PARTITION BY CLASS_CODE ORDER BY AMT DESC) AS rn
   FROM
     HOUSEHOLD_AGGREGATE
   WHERE
     PERSON_CODE != '1' AND CLASS_CODE != '01'
  ) t1
INNER JOIN
  (SELECT
     CLASS_CODE,
     PERSON_NAME,
     AMT
   FROM
     HOUSEHOLD_AGGREGATE
   WHERE
     PERSON_CODE != '1' AND CLASS_CODE != '01'
  ) t2
ON t1.CLASS_CODE = t2.CLASS_CODE AND t1.rn = 1
ORDER BY
  t1.CLASS_CODE ASC;