alirsLofty 12
Updated 2022-07-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with assets as (
SELECT
asset_name, asset_id
FROM algorand.asset
WHERE creator_address = 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'
AND asset_deleted != 'TRUE'
AND asset_name != 'Lofty AI'
)
SELECT
count(DISTINCT att.asset_receiver) as unique_wallets_count,
count(att.asset_receiver) as wallets_count,
att.asset_id,
assets.asset_name
from algorand.asset_transfer_transaction att join assets on att.asset_id = assets.asset_id
where att.asset_id in (select asset_id from assets)
group by 3,4
order by 1,2
Run a query to Download Data