COUNT (DISTINCT a.PAYER) as new_payer,

SUM (new_payer) OVER (ORDER BY "date") as acm_new_payer

FROM (

Select BLOCK_TIMESTAMP::date as "date",

PAYER,

ROW_NUMBER() OVER (PARTITION BY PAYER ORDER BY "date") as SrNo

FROM ethereum.maker.ez_repayments

WHERE BLOCK_TIMESTAMP >= '2022-01-01' AND TX_STATUS = 'SUCCESS'

) a

WHERE a.SrNo = 1

GROUP BY a."date"

ORDER BY a."date"