PURCHASER,

Sum(SALES_AMOUNT) AS All_sales_amount,

COUNT(DISTINCT TX_ID) AS Number_of_sales

from flipside_prod_db.solana.fact_nft_sales

WHERE BLOCK_TIMESTAMP>='2022-01-01'

AND SUCCEEDED=TRUE

GROUP BY 1

ORDER BY 2 DESC

limit 10