rajsUsers by Overall # of Txs on Flow
Updated 2022-09-14
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
›
⌄
SELECT
txs,
count(proposer) as no_of_users
FROM
(
SELECT
proposer,
case when count(*) > 1000 then 'More than 1000 txs'
when count(*) >= 100 and count(*) <= 1000 then '100-1000 txs'
when count(*) >= 10 and count(*) <= 100 then '10-99 txs'
when count(*) < 10 then 'Less than 10 txs'
end as txs,
count(*) as no_of_txs
from flow.core.fact_transactions
-- where tx_id = 'c422c0848a96e90b8aa688aa5f36dd984013f73a1e416bb3a3fc8343646fa610'
where proposer IN
(
SELECT
buyer
from flow.core.ez_nft_sales s
where s.nft_collection = 'A.e4cf4bdc1751c65d.AllDay'
)
group by 1
order by 3 desc
-- limit 1
)
group by 1
order by 2 desc
Run a query to Download Data