HadisehTop 20 users
Updated 2025-02-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
WITH UserActivity AS (
SELECT
FROM_ADDRESS AS user,
CASE
WHEN BLOCK_TIMESTAMP < '2025-02-19' THEN 'Private'
ELSE 'Public'
END AS network_phase,
TX_HASH
FROM
monad.testnet.fact_transactions
)
SELECT
user,
network_phase,
COUNT(DISTINCT TX_HASH) AS total_transactions,
DENSE_RANK() OVER (
ORDER BY
total_transactions DESC
) AS activity_rank
FROM
UserActivity
GROUP BY
user,
network_phase QUALIFY activity_rank <= 20
ORDER BY
total_transactions DESC,
network_phase DESC;
QueryRunArchived: QueryRun has been archived