select project_name as Project, count(project_name) as Count, sum(price_usd) as Price_in_USD, Avg(price_usd) as Average_Price, platform_name as Platform, event_type as Event
from ethereum.core.ez_nft_sales
where price_usd>0
and project like '%boredapeyachtclub'
group by project_name, platform_name, event_type
order by Price_in_USD desc;