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