SELECT wk.CLASS_NAME AS CLASS
      ,wk.PERSON_NAME AS PERSON
      ,wk.AMT AS HOUSEHOLDS
FROM(
SELECT CLASS_CODE
      ,CLASS_NAME
      ,PERSON_NAME
      ,AMT
      ,RANK() OVER(PARTITION BY CLASS_NAME ORDER BY AMT DESC) AS r
  FROM HOUSEHOLD
 WHERE PERSON_CODE != '1'
   AND CLASS_CODE != '01'
)wk
WHERE wk.r = 1