SELECT
  a.class_name AS CLASS,
  a.person_name AS PERSON,
  a.amt AS HOUSEHOLDS
FROM
  household a
  JOIN (
    SELECT
      person_code,
      class_code,
      max(amt)
    FROM
      household
    WHERE
      NOT (PERSON_CODE = '1' or CLASS_CODE = '01')
    GROUP BY
      class_code
  ) b ON a.person_code = b.person_code
  AND a.class_code = b.class_code
ORDER BY
  a.class_code ASC;