SELECT CLASS_NAME AS CLASS, MAX(PERSON_NAME) AS PERSON, MAX(AMT) AS HOUSEHOLDS
  FROM HOUSEHOLD
 WHERE PERSON_CODE <> '1'
   AND CLASS_CODE <> '01'
 GROUP BY CLASS_NAME
 ORDER BY CLASS_CODE ASC