SELECT
  HOUSEHOLD.CLASS_NAME AS CLASS,
  HOUSEHOLD.PERSON_NAME AS PERSON,
  HOUSEHOLD.AMT AS HOUSEHOLDS
FROM HOUSEHOLD
  INNER JOIN (
    SELECT
      CLASS_CODE,
      MAX(AMT) AS MAX_AMT
    FROM HOUSEHOLD
    WHERE
      PERSON_CODE <> '1'
      AND CLASS_CODE <> '01'
    GROUP BY CLASS_CODE
  ) tmp
  ON HOUSEHOLD.CLASS_CODE = tmp.CLASS_CODE
    AND HOUSEHOLD.AMT = tmp.MAX_AMT
ORDER BY HOUSEHOLD.CLASS_CODE ASC