pepperatziCreators Range of Contracts
Updated 2025-02-20
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
›
⌄
with base as (
select
created_block_timestamp,
address,
creator_address,
from monad.testnet.dim_contracts
where date_trunc('hour', created_block_timestamp) >= '2025-02-19 16:00:00'
),
environment as (
select
creator_address,
count(distinct address) as total_contract_deployed
from base
group by 1
)
select
case when total_contract_deployed = 1 then '1 contract_deployed'
when total_contract_deployed between 1 and 5 then '1-5 contracts deployed'
when total_contract_deployed between 5 and 10 then '5-10 contracts deployed'
when total_contract_deployed between 10 and 20 then '10-20 contracts deployed'
when total_contract_deployed > 20 then '>20 contracts_deployed'
end as contracts_Range,
count(distinct creator_address) as users
from environment
group by 1
QueryRunArchived: QueryRun has been archived