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