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