KaskoazulSellers crossover
    Updated 2022-10-30
    with total_sellers as (
    select seller,
    marketplace,
    sum(sales_amount) as volume
    from solana.core.fact_nft_sales
    where block_timestamp >= '2022-10-01' and block_timestamp < CURRENT_DATE
    and marketplace in ('coral cube', 'hyperspace', 'hadeswap')
    group by 1, 2
    order by 1
    ),

    cross_over_index as (
    select seller,
    count(seller) as cross_over
    from total_sellers
    group by seller
    )

    select s.seller,
    sum(s.volume) as total_volume,
    c.cross_over
    from total_sellers s
    right join cross_over_index c
    on s.seller = c.seller
    group by 1,3
    Run a query to Download Data