TX_CATEGORY | USER_COUNT | |
|---|---|---|
1 | 6-10 Tx | 9347437 |
2 | 1 Tx | 52619937 |
3 | 11-20 Tx | 6722721 |
4 | 2-5 Tx | 24568968 |
5 | 21+ Tx | 4563510 |
Afonso_DiazGrouping users
Updated 6 days ago
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
28
29
30
31
32
›
⌄
WITH main AS (
SELECT
tx_hash,
block_timestamp,
from_address AS user
FROM kaia.core.fact_transactions
),
user_tx_count AS (
SELECT
user,
COUNT(tx_hash) AS tx_count
FROM main
GROUP BY 1
),
categorized_users AS (
SELECT
CASE
WHEN tx_count = 1 THEN '1 Tx'
WHEN tx_count BETWEEN 2 AND 5 THEN '2-5 Tx'
WHEN tx_count BETWEEN 6 AND 10 THEN '6-10 Tx'
WHEN tx_count BETWEEN 11 AND 20 THEN '11-20 Tx'
ELSE '21+ Tx'
END AS tx_category,
COUNT(DISTINCT user) AS user_count
FROM user_tx_count
GROUP BY 1
)
SELECT
tx_category,
user_count
FROM categorized_users
Last run: 6 days ago
5
99B
108s