platform_name,

count(*) as sales_count

from ethereum.core.ez_nft_sales

where block_timestamp > current_date - interval '30 days'

group by platform_name

order by sales_count desc

limit 8