jackguyNew Coinbase L2 Chain 5 copy
Updated 2023-08-09
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
›
⌄
-- forked from c1893b55-2ebd-490b-914f-279c92c28488
SELECT
CASE when transaction = 1 then 'a 1 Transaction'
when transaction < 10 then 'b 2 - 10 Transactions'
when transaction < 50 then 'c 11 - 50 Transactions'
when transaction < 100 then 'd 51 - 100 Transactions'
when transaction < 500 then 'e 101 - 500 Transactions'
when transaction < 1000 then 'f 501 - 1,000 Transactions'
when transaction < 5000 then 'g 1,001 - 5,000 Transactions'
else 'h 5,000+ Transactions' end as User_group,
count(*) as users
FROM (
SELECT
to_address,
count(DISTINCT tx_hash) as transaction,
count(DISTINCT date_trunc('day', block_timestamp)) as active_days
-- count(DISTINCT to_address) as contracts_interacted_with
from base.goerli.fact_transactions
WHERE not to_address in (SELECT from_address FROM base.goerli.fact_transactions)
GROUP BY 1
)
GROUP BY 1
--a
Run a query to Download Data