count(*) as "Number of Sales",

count(distinct seller) as "Number of Sellers",

count(distinct buyer) as "Number of Buyers",

count(distinct NFT_ID) as "Number of NFTs in Collection"

from flow.core.fact_nft_sales

where TX_SUCCEEDED = 'TRUE'

and nft_collection = 'A.e4cf4bdc1751c65d.AllDay'