SELECT  A.CLASS_NAME AS CLASS, MAX(PERSON_NAME) AS PERSON, A.AMT AS HOUSEHOLDS 
  FROM HOUSEHOLD AS A
  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
 GROUP BY A.CLASS_NAME
HAVING PERSON_CODE <> '1'
   AND CLASS_CODE <> '01'
 ORDER BY CLASS_CODE ASC