shreexDimension X 6
    Updated 2023-04-01
    with users as (
    select
    buyer,
    block_timestamp::date as min_date
    from flow.core.ez_nft_sales
    where nft_Collection='A.e3ad6030cbaff1c2.DimensionX')

    select
    RIGHT(nft_collection, CHARINDEX('.', REVERSE(nft_collection))-1) AS nft_collections,
    count(distinct s.buyer) as crossover_buyers,
    count(distinct tx_id) as crossover_buys
    from flow.core.ez_nft_sales s,users where s.buyer=users.buyer and nft_collection != 'A.e3ad6030cbaff1c2.DimensionX'
    GROUP BY nft_collections
    HAVING crossover_buyers> 9
    ORDER BY crossover_buyers DESC
    Run a query to Download Data