headitmanagerwhales holding a CGF
Updated 2022-06-08
9
1
2
3
4
5
6
7
›
⌄
select sum(amount) as hold_amount,address from algorand.account_asset where asset_id
in (select asset_id from algorand.asset where asset_name like '%CGF%' and asset_deleted=0
and asset_id not in (686557990,686557990,710865853,710865853,710865656,710865656,709904840))
and amount>0 and address in (select address from algorand.account
group by address
having sum(balance) > 150000)
group by address
Run a query to Download Data