WITH a AS (
SELECT * FROM HOUSEHOLD
WHERE PERSON_CODE <> '1'
AND CLASS_CODE <>'01'
),
b AS(
SELECT *,
  row_number() over (
    partition by
      CLASS_NAME
    order by AMT desc
  ) amt_rank
 FROM a
)
SELECT CLASS_NAME CLASS,
PERSON_NAME PERSON,
AMT HOUSEHOLDS
FROM b 
WHERE amt_rank=1
;