SELECT
  t2.CLASS_NAME as CLASS
  , t2.PERSON_NAME as PERSON
  , t2.AMT as HOUSEHOLDS
FROM
  HOUSEHOLD t2
  INNER JOIN (
              SELECT
                CLASS_CODE
                ,PERSON_CODE
                , MAX(AMT) AS MAX_AMT
              FROM
                HOUSEHOLD t1
              where PERSON_CODE != '1'
                and CLASS_CODE != '01'
              GROUP BY
                CLASS_CODE
             ) t1
          ON t1.CLASS_CODE = t2.CLASS_CODE
         AND t1.MAX_AMT = t2.AMT
ORDER BY
  t2.CLASS_CODE