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