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 || AMT IN 
  (SELECT CLASS_NAME || MAX(AMT)
     FROM HOUSEHOLD
     WHERE (PERSON_CODE <> '1' AND CLASS_CODE <> '01')
     GROUP BY CLASS_NAME
     )
GROUP BY CLASS_NAME
ORDER BY CLASS_CODE ASC