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
        not PERSON_CODE = '1'
    and not CLASS_CODE  = '01'
)
select
    CLASS
  , PERSON
  , HOUSEHOLDS
from
    with_code
order by
    CLASS_CODE asc