Address | BREAKDOWN | |
|---|---|---|
1 | 12931 | a. 1 txn |
2 | 508 | b. 2 txns |
3 | 1271 | c. 3 txns |
4 | 1892 | d. 4 txns |
5 | 1355 | e. 5 txns |
6 | 1032 | f. 6 txns |
7 | 2700 | g. 7 txns |
8 | 1689 | h. 8 txns |
9 | 1004 | i. 9 txns |
10 | 1307 | j. 10 txns |
11 | 6587 | k. > 10 txns |
hess10. Breakdown of Addresses
Updated 2025-05-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with base as ( select from_address,
count(distinct tx_hash) as txns
from mezo.testnet.fact_transactions
group by 1)
select count(distinct from_address) as "Address",
case
when txns = 1 then 'a. 1 txn'
when txns = 2 then 'b. 2 txns'
when txns = 3 then 'c. 3 txns'
when txns = 4 then 'd. 4 txns'
when txns = 5 then 'e. 5 txns'
when txns = 6 then 'f. 6 txns'
when txns = 7 then 'g. 7 txns'
when txns = 8 then 'h. 8 txns'
when txns = 9 then 'i. 9 txns'
when txns = 10 then 'j. 10 txns'
when txns > 10 then 'k. > 10 txns' end as breakdown
from base
group by 2
order by 2 asc
Last run: 27 days ago
11
213B
2s