badboyUntitled Query
    Updated 2022-11-14
    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