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