primo_datalofty_ai_total_investors
Updated 2023-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
⌄
/* --Property Token Revenue
select 'total', aa.asset_id, aa.asset_name, sum(aa.amount) * 50 as token_revenue_usd
from algorand.account_asset aa
left join algorand.asset a
on aa.asset_id = a.asset_id
where a.creator_address = 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'
and aa.asset_id != '237267329'
and aa.amount > 0
group by 1, 2, 3
order by 4 desc
*/
select count(distinct aa.address) total_investors
from algorand.account_asset aa
left join algorand.asset a
on aa.asset_id = a.asset_id
where a.creator_address = 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'
and aa.asset_id != '237267329'
and aa.amount > 0
Run a query to Download Data