bharath_24907-Ev_dGj2023-08-26 11:25 AM
Updated 2023-08-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
SELECT
CONCAT(
CASE
WHEN MONTH(BLOCK_TIMESTAMP) = 1 THEN 'January'
WHEN MONTH(BLOCK_TIMESTAMP) = 2 THEN 'February'
WHEN MONTH(BLOCK_TIMESTAMP) = 3 THEN 'March'
WHEN MONTH(BLOCK_TIMESTAMP) = 4 THEN 'April'
WHEN MONTH(BLOCK_TIMESTAMP) = 5 THEN 'May'
WHEN MONTH(BLOCK_TIMESTAMP) = 6 THEN 'June'
WHEN MONTH(BLOCK_TIMESTAMP) = 7 THEN 'July'
WHEN MONTH(BLOCK_TIMESTAMP) = 8 THEN 'August'
WHEN MONTH(BLOCK_TIMESTAMP) = 9 THEN 'September'
WHEN MONTH(BLOCK_TIMESTAMP) = 10 THEN 'October'
WHEN MONTH(BLOCK_TIMESTAMP) = 11 THEN 'November'
WHEN MONTH(BLOCK_TIMESTAMP) = 12 THEN 'December'
END,
' ',
YEAR(BLOCK_TIMESTAMP)
) AS month_and_year,
COUNT(*) AS "No. of NFTs Minted"
FROM
solana.core.fact_nft_mints
WHERE
IS_COMPRESSED = TRUE
GROUP BY
YEAR(BLOCK_TIMESTAMP),
MONTH(BLOCK_TIMESTAMP)
HAVING
CONCAT(
YEAR(BLOCK_TIMESTAMP),
'-',
MONTH(BLOCK_TIMESTAMP)
) <> CONCAT(
YEAR(CURRENT_TIMESTAMP),
'-',
Run a query to Download Data