COUNT(distinct tx_ID) as transaction_count,

sum(price) as sale_volume,

sale_volume / transaction_count as average_volume_per_sale

FROM flow.core.fact_nft_sales

WHERE nft_collection = 'A.e4cf4bdc1751c65d.AllDay'

AND tx_succeeded = 'TRUE'