SELECT
 A.CLASS_NAME AS CLASS,
 A.PERSON_NAME AS PERSON,
 A.AMT AS HOUSEHOLDS
FROM
 HOUSEHOLD AS A
JOIN (
 SELECT
  CLASS_NAME,
  MAX(AMT) AS MAX
 FROM
  HOUSEHOLD
 WHERE
 PERSON_CODE != '1'
 AND
  CLASS_CODE != '01'
 GROUP BY
  CLASS_NAME
) AS B
ON
 A.CLASS_NAME = B.CLASS_NAME
AND
 A.AMT = B.MAX
ORDER BY
 CLASS_CODE ASC;