with with_code as (
select distinct
        NTH_VALUE(CLASS_NAME , 1) OVER(PARTITION BY CLASS_CODE ORDER BY AMT DESC RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) as CLASS
      , NTH_VALUE(CLASS_CODE , 1) OVER(PARTITION BY CLASS_CODE ORDER BY AMT DESC RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) as CLASS_CODE
      , NTH_VALUE(PERSON_NAME, 1) OVER(PARTITION BY CLASS_CODE ORDER BY AMT DESC RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) as PERSON
      , NTH_VALUE(AMT        , 1) 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