SELECT
  master.CLASS,
  amt.PERSON,
  amt.AMT HOUSEHOLDS
FROM (
  SELECT
    CLASS_NAME CLASS,
    CLASS_CODE CODE
  FROM
    HOUSEHOLD
  WHERE
    PERSON_CODE = '1'
  GROUP BY CLASS_NAME
) master
INNER JOIN (
  SELECT
    CLASS_NAME CLASS,
    max(AMT) AMT
  FROM HOUSEHOLD
  WHERE PERSON_CODE != '1'
  GROUP BY CLASS_NAME
) maxamt
ON master.CLASS = maxamt.CLASS
INNER 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.CODE
;