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'
order by
   CLASS asc
)
select
    CLASS
  , PERSON
  , HOUSEHOLDS
from
    with_code