SELECT
  a.class_name AS CLASS,
  a.person_name AS PERSON,
  b.AMT AS HOUSEHOLDS
FROM
  household a
  JOIN (
    SELECT
      person_code,
      class_code,
      max(amt) AS AMT
    FROM
      household
    WHERE
      person_code != '1'
      AND 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;