select event_type, project_name, sum(price_usd) as sales_volume from
(
select * from ethereum.core.ez_nft_sales
where
-- event_type = 'sale'
--and
platform_name='nftx'
and block_timestamp >= CURRENT_DATE - 60
and price_usd > 0
)
group by event_type, project_name
order by sales_volume desc