SELECT INITCAP(REPLACE(l.label, '_', ' ')) AS collection

, ROUND(SUM(sales_amount)) AS volume

FROM solana.core.fact_nft_sales s

JOIN solana.core.dim_labels l

ON l.address = s.mint

WHERE succeeded

AND s.block_timestamp >= DATEADD('hours', -30 * 24, CURRENT_TIMESTAMP)

GROUP BY 1

), t1 AS (

SELECT *

, ROW_NUMBER() OVER (ORDER BY volume DESC) AS rk

, CONCAT(LPAD(to_varchar(rk), 2, '0'), '. ', collection) AS label

FROM t0

SELECT *

FROM t1

WHERE rk <= 10