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