WITH T1 AS (
SELECT  CLASS_NAME  AS CLASS
       ,PERSON_NAME AS PERSON
       ,SUM(AMT) AS SUM_AMT
       ,MAX(AMT) OVER (PARTITION BY CLASS_NAME)    AS HOUSEHOLDS
  FROM HOUSEHOLD
 WHERE PERSON_CODE <> '1'
   AND CLASS_CODE  <> '01'
 GROUP BY  CLASS
          ,PERSON
)
SELECT  CLASS
       ,PERSON
       ,HOUSEHOLDS
  FROM T1 AS T
 WHERE SUM_AMT = HOUSEHOLDS
ORDER BY CLASS