kiichiUntitled Query
Updated 2022-06-20
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
›
⌄
with pa1 as (
select asset_id from algorand.asset
where asset_name like 'Warrior Croc%'
and creator_address = 'A62XRVE7ZWSXLAA4YDDI7GUMCHML2TT3JXFT3OWTVQAKOZSBGNT7FX5YQU'
or creator_address = 'SRRIUGPVPPGST3KPH32XQXTE567G6LHCEX2IMHDRW2IWH3427UVWXRXHCQ'
),
pa2 as (
SELECT
address,
amount,
asset_id
from flipside_prod_db.algorand.account_asset
where amount >0
)
SELECT
b.address,
sum (c.balance) as algo_balance,
count (b.amount) as wildlife_warriors_amount
from pa1 a
left join pa2 b
on a.asset_id = b.asset_id
left join flipside_prod_db.algorand.account c
on b.address=c.address
group by b.address
Run a query to Download Data