with with_code as (
select distinct
        FIRST_VALUE(CLASS_NAME ) OVER(PARTITION BY CLASS_CODE ORDER BY AMT DESC RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) as CLASS
      , FIRST_VALUE(CLASS_CODE ) OVER(PARTITION BY CLASS_CODE ORDER BY AMT DESC RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) as CLASS_CODE
      , FIRST_VALUE(PERSON_NAME) OVER(PARTITION BY CLASS_CODE ORDER BY AMT DESC RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) as PERSON
      , FIRST_VALUE(AMT        ) OVER(PARTITION BY CLASS_CODE ORDER BY AMT DESC RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) as HOUSEHOLDS
    from
        HOUSEHOLD
    where
        PERSON_CODE <> '1'
    and CLASS_CODE  <> '01'
)
select
    CLASS
  , PERSON
  , HOUSEHOLDS
from
    with_code
order by
   CLASS_CODE asc