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
      person_code != '1'
    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;