, COUNT(tx_id)

, AVG(sales_amount)

FROM solana.core.fact_nft_sales

JOIN solana.core.dim_labels

ON fact_nft_sales.mint = dim_labels.address

WHERE address_name = 'solana monkey business'

AND block_timestamp >= CURRENT_DATE -7