SELECT
 CLASS_NAME AS CLASS,
 PERSON_NAME AS PERSON,
 AMT AS HOUSEHOLDS
FROM
 HOUSEHOLD
WHERE
 PERSON_CODE <> "1"
 AND CLASS_CODE <> "01"
 AND AMT = (SELECT
  MAX(AMT)
  FROM HOUSEHOLD AS H2
  WHERE HOUSEHOLD.CLASS_NAME = H2.CLASS_NAME
   AND PERSON_CODE <> "1"
   AND CLASS_CODE <> "01"
  GROUP BY CLASS_NAME
 )
ORDER BY CLASS_CODE ASC;