project_name,

COUNT(tokenid) AS nfts_sold,

SUM(price_usd) AS Volume,

COUNT(DISTINCT tx_hash) AS Transaction

FROM

base.nft.ez_nft_sales

WHERE

platform_name = 'opensea'

AND project_name IS NOT NULL

GROUP BY

project_name

ORDER BY nfts_sold DESC

limit 20;