SELECT 
  CLASS_NAME AS CLASS,
  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