cryptallUSERS WITH THE MOST TRANSACTIONS
Updated 2024-07-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
SELECT
USER_ADDRESS,
COUNT(*) AS TRANSACTION_COUNT
FROM
(
SELECT
CASE
WHEN FROM_ADDRESS = '0x3043988aa54bb3ae4da60ecb1dc643c630a564f0' THEN TO_ADDRESS
ELSE FROM_ADDRESS
END AS USER_ADDRESS
FROM
kaia.core.fact_transactions
WHERE
FROM_ADDRESS = '0x3043988aa54bb3ae4da60ecb1dc643c630a564f0'
OR TO_ADDRESS = '0x3043988aa54bb3ae4da60ecb1dc643c630a564f0'
) AS user_transactions
GROUP BY
USER_ADDRESS
ORDER BY
TRANSACTION_COUNT DESC
LIMIT 10;
QueryRunArchived: QueryRun has been archived