SELECT
  CLASS_NAME AS CLASS,
  PERSON_NAME AS PERSON,
  AMT AS HOUSEHOLDS
FROM HOUSEHOLD
WHERE
  PERSON_CODE <> '1'
  AND CLASS_CODE <> '01'
  AND NOT EXISTS (
    SELECT 1
    FROM HOUSEHOLD sub
    WHERE
      HOUSEHOLD.CLASS_CODE = sub.CLASS_CODE
      AND HOUSEHOLD.AMT < sub.AMT
      AND PERSON_CODE <> '1'
      AND CLASS_CODE <> '01'
  )
ORDER BY CLASS_CODE ASC