WITH R AS (
 SELECT
      CLASS_NAME
     ,CLASS_CODE
     ,PERSON_NAME
     ,AMT
     ,RANK() OVER(PARTITION BY CLASS_NAME ORDER BY AMT DESC) AS RESULT
  FROM HOUSEHOLD
 WHERE PERSON_CODE <> '1'
   AND CLASS_CODE <> '01'
)
SELECT CLASS_NAME AS CLASS
      ,PERSON_NAME AS PERSON
      ,AMT AS HOUSEHOLDS
  FROM R
 WHERE RESULT = 1
 ORDER BY CLASS_CODE