kasadeghUntitled Query
Updated 2022-11-13
9
1
2
3
4
5
6
7
8
›
⌄
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 '{{Wallet_Address}}'
group by 1,2
order by 3 desc
Run a query to Download Data