feyikemiUsers Dist by txns
Updated 2025-01-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
WITH tb1 AS (
SELECT
FROM_ADDRESS,
COUNT(DISTINCT TX_HASH) AS TRANSACTIONS
FROM kaia.core.fact_transactions
WHERE block_timestamp::date >= '2024-01-01'
GROUP BY FROM_ADDRESS
)
SELECT
CASE
WHEN TRANSACTIONS = 1 THEN '1 Transaction'
WHEN TRANSACTIONS BETWEEN 2 AND 5 THEN '2 - 5 Transactions'
WHEN TRANSACTIONS BETWEEN 6 AND 10 THEN '6 - 10 Transactions'
WHEN TRANSACTIONS BETWEEN 11 AND 25 THEN '11 - 25 Transactions'
WHEN TRANSACTIONS BETWEEN 26 AND 50 THEN '26 - 50 Transactions'
ELSE '> 50 Transactions'
END AS user_type,
COUNT(FROM_ADDRESS) AS USERS
FROM tb1
GROUP BY user_type
ORDER BY Users DESC
QueryRunArchived: QueryRun has been archived