SELECT DISTINCT A.CLASS_NAME  AS CLASS
              , A.PERSON_NAME AS PERSON
              , MAX(AMT)      AS HOUSEHOLDS 
  FROM HOUSEHOLD AS A
  LEFT JOIN (SELECT MAX(PERSON_NAME) AS PERSON_NAME
               FROM HOUSEHOLD)       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