SELECT  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