contract_name,

sum(sales_amount) as Volume

from solana.core.fact_nft_sales a

join solana.core.dim_nft_metadata b on a.mint = b.mint

where block_timestamp >= CURRENT_DATE -90 and block_timestamp < CURRENT_DATE

and succeeded = 'TRUE'

and marketplace in ('yawww')

group by 1

order by 2 desc

limit 10