john-adamUntitled Query
    WITH new AS (
    SELECT TX_SIGNER, MIN(a.BLOCK_TIMESTAMP) AS min
    FROM a JOIN AVVE.core.fact_transactions t
    ON a.TX_HASH = t.TX_HASH
    WHERE a.METHOD_NAME='nft_buy'
    GROUP BY 1
    HAVING min> CURRENT_DATE()-90
    ORDER BY 2)

    SELECT COUNT(DISTINCT TX_SIGNER) AS n_new
    FROM NEW
    Run a query to Download Data