SELECT fact_nft_sales.purchaser as buyer , COUNT(fact_nft_sales.sales_amount) AS N_NFTs, MIN(fact_nft_sales.block_timestamp) AS BUY_DATE
from solana.fact_nft_sales INNER JOIN solana.dim_nft_metadata
WHERE fact_nft_sales.mint = dim_nft_metadata.mint
AND fact_nft_sales.marketplace LIKE '%magic%'
AND fact_nft_sales.succeeded = 'true'
AND fact_nft_sales.block_timestamp >= '2022-02-05'
AND dim_nft_metadata.contract_name like '%Lightning%'
GROUP BY purchaser
order by buy_date desc