SELECT
  CLASS_NAME AS CLASS,
  PERSON_NAME AS PERSON,
  AMT AS HOUSEHOLDS
FROM
  HOUSEHOLD H1
WHERE
  AMT = (
SELECT
  MAX(AMT)
FROM
  HOUSEHOLD H2
WHERE
  PERSON_CODE <> '1'
AND
  H1.CLASS_NAME = H2.CLASS_NAME
GROUP BY
  CLASS_CODE,
  CLASS_NAME
HAVING
  CLASS_CODE <> '01'
)
ORDER BY
  CLASS_CODE
;