COUNT(DISTINCT CASE WHEN event_type = 'bid_won' THEN tx_hash else NULL end) AS total_bid_won,

COUNT(DISTINCT CASE WHEN event_type = 'sale' THEN tx_hash else null end) AS total_sales,

COUNT(DISTINCT tx_hash) AS total_transactions,

COUNT(erc1155_value) AS ERC_SALES,

SUM(price_usd) AS total_price_usd,

SUM(total_fees_usd) AS total_fees_usd,

SUM(platform_fee_usd) AS platform_fees,

SUM(creator_fee_usd) AS creator_fees,

SUM(tx_fee_usd) AS transaction_fees

base.nft.ez_nft_sales;