SELECT  A.CLASS_NAME AS CLASS, MAX(PERSON_NAME) AS PERSON, A.AMT AS HOUSEHOLDS 
  FROM HOUSEHOLD AS A
  INNER JOIN (SELECT CLASS_NAME, MAX(AMT) AS AMT
              FROM HOUSEHOLD
             WHERE PERSON_CODE <> '1'
               AND CLASS_CODE <> '01'
             GROUP BY CLASS_NAME) AS B
    ON  A.AMT = B.AMT
 WHERE PERSON_CODE <> '1'
   AND CLASS_CODE <> '01'
 GROUP BY A.CLASS_NAME
 ORDER BY CLASS_CODE ASC