MetiocreFig 8. Top 10 Highest Al-Goanna sales
Updated 2022-05-26
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
29
›
⌄
with goanas as (
select *
from
flipside_prod_db.algorand.asset
where creator_address='D5J7H7PIYKLY2U6A5OFUAC7GQHTHSXXNX65DSD3CJYPBV2MVK6NTNW44CA'
and asset_name ILIKE 'AL Goanna%'
),
sale_tx_groups as (
select distinct tx_group_id,
asset_id
from
algorand.transfers as t
join goanas using(asset_id)
)
select pt.tx_group_id,
sale_tx_groups.asset_id,
pt.sender,
pt.receiver,
pt.amount,
row_number() over (order by pt.amount desc) as rank
from
algorand.payment_transaction as pt
join sale_tx_groups on pt.tx_group_id = sale_tx_groups.tx_group_id
where
pt.asset_id=0
and pt.amount > 0
qualify rank <= 10
Run a query to Download Data