SELECt
CLASS,
  PERSON,
  HOUSEHOLDS
  FROM
  (
SELECT
  CLASS_NAME CLASS,
  PERSON_NAME PERSON,
  AMT HOUSEHOLDS,
  ROW_NUMBER(*)OVER(PARTITION BY CLASS_CODE
  ORDER BY AMT DESC) row
FROM
  HOUSEHOLD
WHERE
PERSON_CODE <> '1'
AND CLASS_CODE <> '01'
)
WHERE row=1
ORDER BY
CLASS