s.platform_name,

ROUND(SUM(s.price), 2) AS sum_of_sale,

ROUND(AVG(s.price), 2) AS avg_price_ETH

ethereum.nft.dim_nft_metadata m,

ethereum.nft.ez_nft_sales s

m.project_name LIKE '%bored_ape_yacht_club%'

AND s.tokenid = m.token_id

AND s.currency_symbol = 'ETH'

AND s.event_type = 'sale'

GROUP BY

s.platform_name,

m.project_name

ORDER BY

sum_of_sale DESC