Tobi_12024-07-02 10:07 AM
Updated 2024-07-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
⌄
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;