NavidCopy of Untitled Query
    Updated 2022-10-10
    select
    address_name,
    count(distinct TX_ID) as total_number_of_sales,
    count(distinct PURCHASER) as total_unique_buyers,
    count(distinct SELLER) as total_unique_sellers,
    sum(SALES_AMOUNT) as total_sales_price
    -- , MARKETPLACE
    from
    solana.core.fact_nft_sales a join solana.core.dim_labels b on a.MINT=b.ADDRESS
    -- solana.core.fact_nft_mints
    where
    SUCCEEDED and
    address_name in ('Hockey Heroes','Collectorz Club: The Collectorz','collectorz club gen1','The Suites','Laidback Lions','Sports Rewind')
    group by
    1
    order by
    1 asc

    Run a query to Download Data