SELECT
  CLASS_NAME AS CLASS
  , PERSON_NAME AS PERSON
  , AMT AS HOUSEHOLDS
FROM
  (
  SELECT
    *
    , row_number() over (partition by CLASS_CODE order by AMT DESC) row
  FROM
    HOUSEHOLD
  WHERE
    PERSON_CODE != '1'
    AND CLASS_CODE != '01'
  ORDER BY
    AMT
  ) A
WHERE
  row = 1
ORDER BY
  CLASS_CODE