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 AMT
                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.AMT
 ORDER BY CLASS_CODE ASC