WITH T1 AS (
  SELECT  CLASS_NAME
         ,MAX(AMT) AS MAX_AMT
    FROM HOUSEHOLD
   WHERE PERSON_CODE <> '1'
     AND CLASS_CODE <> '01'
   GROUP BY CLASS_NAME
)
SELECT  H.CLASS_NAME  AS CLASS
       ,H.PERSON_NAME AS PERSON
       ,T.MAX_AMT AS HOUSEHOLDS
  FROM HOUSEHOLD AS H
 INNER JOIN T1 AS T
    ON H.CLASS_NAME = T.CLASS_NAME
   AND H.AMT        = T.MAX_AMT
 ORDER BY H.CLASS_CODE