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