where ORIGIN_from_ADDRESS = lower('0x0000000000000000000000000000000000000000')

and ORIGIN_to_ADDRESS = lower('0x0000000000000000000000000000000000000000')

and TX_STATUS = 'SUCCESS'

GROUP by 1,2

),

tbl1 AS (SELECT b.TX_HASH, PROJECT_NAME, b.ORIGIN_TO_ADDRESS, b.EVENT_NAME ,ROW_NUMBER() OVER(PARTITION BY b.ORIGIN_TO_ADDRESS order by b.BLOCK_TIMESTAMP ) as next_tx

FROM bridge a INNER JOIN polygon.core.fact_event_logs b ON a.wallet = b.ORIGIN_FROM_ADDRESS

join polygon.core.dim_labels c

on b.CONTRACT_ADDRESS = c. ADDRESS

WHERE b.BLOCK_TIMESTAMP > a.BLOCK_TIMESTAMP

)

SELECT PROJECT_NAME,

COUNT(DISTINCT tx_hash) as txn

FROM tbl1

WHERE PROJECT_NAME is not NULL

group by PROJECT_NAME

order by 2 desc

limit 10