project_name,

SUM(platform_fee_usd) AS Platform_fees,

SUM(creator_fee_usd) AS Creator_fee,

FROM

base.nft.ez_nft_sales

WHERE

platform_name = 'opensea'

AND project_name IS NOT NULL

GROUP BY

project_name

ORDER BY Platform_fees DESC

LIMIT 5;