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