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