SELECT *

FROM solana.core.fact_nft_sales s

JOIN solana.core.dim_labels l

ON l.address = s.mint

WHERE succeeded = TRUE

AND l.label in ('genesis genopets habitats', 'genopets habitats')

)

SELECT date_trunc("week", BLOCK_TIMESTAMP) as week, LABEL, count(*) as nb_trades

FROM sales

GROUP BY 1, 2