Afonso_Diaz2023-02-03 03:00 PM
Updated 2023-02-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with t1 as (
select tx_sender,
count (distinct tx_id) as txns_count
from terra.core.fact_transactions
where fee_denom = 'uluna'
group by 1
)
select
case
when txns_count = 1 then '1 Transaction'
when txns_count <= 10 then 'Between 1 - 10 Transactions'
when txns_count <= 50 then 'Between 10 - 50 Transactions'
when txns_count <= 100 then 'Between 50 - 100 Transactions'
when txns_count <= 1000 then 'Between 100 - 1000 Transactions'
else 'More Than 1000 Transactions' end as type,
count (distinct tx_sender) as txns_count
from t1
group by 1
Run a query to Download Data