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