SELECT
  table1.CLASS_NAME AS CLASS,
  MAX(table1.PERSON_NAME) AS PERSON,
  MAX(table1.AMT) AS HOUSEHOLDS
FROM
  (
    SELECT
      PERSON_NAME,
      CLASS_NAME,
      AMT
    FROM
      HOUSEHOLD
    WHERE
      CLASS_CODE <> '01'
    AND
      PERSON_CODE > 1    
  ) AS table1
GROUP BY
  CLASS
ORDER BY
  CLASS