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