CONTRACT_COUNT_CATEGORY | ADDRESS_COUNT | |
---|---|---|
1 | 1 contract | 704 |
2 | More than 20 contracts | 108 |
3 | 11-20 contracts | 218 |
4 | 2-5 contracts | 1251 |
5 | 6-10 contracts | 310 |
Updated 2025-01-26
999
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
33
34
35
36
›
⌄
SELECT
contract_count_category,
COUNT(origin_from_address) AS address_count
FROM (
SELECT
origin_from_address,
COUNT(DISTINCT contract_address) AS distinct_contract_count,
CASE
WHEN COUNT(DISTINCT contract_address) = 1 THEN '1 contract'
WHEN COUNT(DISTINCT contract_address) BETWEEN 2 AND 5 THEN '2-5 contracts'
WHEN COUNT(DISTINCT contract_address) BETWEEN 6 AND 10 THEN '6-10 contracts'
WHEN COUNT(DISTINCT contract_address) BETWEEN 11 AND 20 THEN '11-20 contracts'
ELSE 'More than 20 contracts'
END AS contract_count_category
FROM flow.core_evm.fact_event_logs
GROUP BY
origin_from_address
) AS categorized
GROUP BY
contract_count_category;
Last run: 20 days ago
5
121B
1s