SELECT
   CLASS
  ,PERSON
  ,MAX(HOUSEHOLDS) AS HOUSEHOLDS
FROM
  (

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