SELECT
  master.CLASS,
  amt.PERSON,
  amt.AMT HOUSEHOLDS
FROM (
  SELECT
    CLASS_NAME CLASS
  FROM
    HOUSEHOLD
  WHERE
    PERSON_CODE = 1
  GROUP BY CLASS_NAME
) master
JOIN (
  SELECT
    CLASS_NAME CLASS,
    max(AMT) AMT
  FROM HOUSEHOLD
  WHERE PERSON_CODE != 1
  GROUP BY CLASS_NAME
) maxamt
ON master.CLASS = maxamt.CLASS
JOIN (
  SELECT
    CLASS_NAME CLASS,
    PERSON_NAME PERSON,
    AMT
  FROM HOUSEHOLD
  WHERE PERSON_CODE != 1
) amt
ON maxamt.CLASS = amt.CLASS AND maxamt.AMT = amt.AMT
ORDER BY master.CLASS_CODE
;