Tobi_12024-07-02 10:07 AM
    Updated 2024-07-02
    WITH recent_sales AS (
    SELECT
    SELLER
    FROM
    solana.nft.fact_nft_sales;
    WHERE
    BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_TIMESTAMP)
    AND SUCCEEDED = TRUE
    ),
    unique_sellers AS (
    SELECT DISTINCT
    SELLER
    FROM
    recent_sales
    )
    SELECT
    COUNT(SELLER) AS total_unique_sellers
    FROM
    unique_sellers;