MahrooUntitled Query
    Updated 2022-10-29
    with coralt as (
    select distinct seller
    from solana.core.fact_nft_sales
    where succeeded = 'TRUE'
    and marketplace in ('coral cube')),

    hypert as (
    select distinct seller
    from solana.core.fact_nft_sales
    where succeeded = 'TRUE'
    and marketplace in ('hyperspace'))

    select 'Used Both Marketplaces' as type,
    count (distinct seller) as Users_Count
    from coralt where seller in (select seller from hypert)

    union ALL

    select 'Used Only HyperSpace' as type,
    count (distinct seller) as Users_Count
    from hypert where seller not in (select seller from coralt)

    union ALL

    select 'Used Only Coral Cube' as type,
    count (distinct seller) as Users_Count
    from coralt where seller not in (select seller from hypert)
    Run a query to Download Data