0xtoshi2024-06-19 02:09 PM
Updated 2024-06-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
With LayerzeroUsers as (
SELECT SENDER_WALLET, COUNT(SOURCE_TRANSACTION_HASH) as countTx
FROM external.layerzero.fact_transactions_snapshot
GROUP BY 1
),
Minimum20 as (
SELECT
ROW_NUMBER() OVER (
ORDER BY SENDER_WALLET
) id,
SENDER_WALLET
FROM LayerzeroUsers
WHERE countTx >= 20
)
SELECT *
FROM Minimum20
ORDER BY 1 ASC
LIMIT 100000
OFFSET 0
QueryRunArchived: QueryRun has been archived