feyikemi2024-03-28 06:43 PM
Updated 2024-03-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
With Frogana AS (
SELECT
NFT_Name,
NFT_collection_name,
mint
FROM
solana.nft.dim_nft_metadata
WHERE
nft_collection_name iLIKE '%Frogana%'
)
SELECT
date_trunc('day', block_timestamp) AS Date,
COUNT(DISTINCT NFT_Name) AS Frogana
FROM
solana.nft.fact_nft_sales s
JOIN frogana f ON s.mint = f.mint
GROUP BY
1
QueryRunArchived: QueryRun has been archived