platform_name,

count(*) as sales_count,

SUM(DISTINCT(price_usd)) as sales_volume

from

ethereum.nft.ez_nft_sales

where block_timestamp > current_date - interval '30 days'

group by platform_name

order by sales_volume desc

limit 7