re_anntotal sales over the months
Updated 2024-04-28
9
1
2
3
4
5
6
7
›
⌄
SELECT DATE_TRUNC('month', BLOCK_TIMESTAMP) AS Month, -- Selects the month component of the BLOCK_TIMESTAMP and aliases it as "Month"
CURRENCY_ADDRESS, -- Selects the CURRENCY_ADDRESS column
SUM(TOTAL_PRICE_USD) AS TotalSalesUSD -- Calculates the total sales amount in USD and aliases it as "TotalSalesUSD"
FROM aptos.nft.ez_nft_sales -- Specifies the table "aptos.nft.ez_nft_sales" from which to retrieve data
GROUP BY Month, CURRENCY_ADDRESS -- Groups the results by Month and CURRENCY_ADDRESS
ORDER BY Month; -- Orders the results by Month in ascending order
QueryRunArchived: QueryRun has been archived