john-adamUntitled Query
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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