SELECT
  DISTINCT(CLASS_NAME) AS CLASS,
  PERSON_NAME AS PERSON,
  AMT AS HOUSEHOLDS
FROM
  HOUSEHOLD
WHERE
  AMT IN (
SELECT
  MAX(DISTINCT AMT)
FROM
  HOUSEHOLD
WHERE
  PERSON_CODE <> '1'
AND
  CLASS_CODE <> '01'
GROUP BY
  CLASS_CODE,
  CLASS_NAME
)
ORDER BY
  CLASS_CODE
;