badboyUntitled Query
Updated 2022-11-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
select
drop_name,
rarity,
count (distinct nft_asset_id)
as
NFTs_Count
from algorand.core.fact_account_asset t1
join algorand.nft.ez_nft_metadata_fifa t2
on t1.asset_id = t2.nft_asset_id
where t1.amount > 0
and address ilike 'UK26A6U7NWJO2KX2N7PCNVXEY4DQ6ZIUBAGNKZF42O7YYI7KOK3C4AARMY'
group by 1,2
order by 3 desc
Run a query to Download Data