barbodUntitled Query
Updated 2022-05-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with tb1 as (select
*
from algorand.application_call_transaction
where try_base64_decode_string(tx_message:txn:note::string) = 'ab2.gallery'
)
select
distinct SENDER as purchasers,
count(tx_group_id) as count_sale,
sum(AMOUNT) as daily_algo
from algorand.payment_transaction
where tx_group_id in (select tx_group_id from tb1)
group by 1 order by 2 desc limit 20
Run a query to Download Data