count (distinct tx_hash) as Sales_Count,

count (distinct buyer_address) as Buyers_Count,

count (distinct seller_address) as Sellers_Count,

count (distinct tokenid) as Tokens_Count,

count (distinct nft_address) as Collections_Count,

count (distinct platform_name) as Platforms_Count,

sum (price_usd) as Total_Sales_Volume,

avg (price_usd) as Average_Sales_volume,

median (price_usd) as median_sale_volume,

min (price_usd) as minimum_sale_volume,

max (price_usd) as maximum_sale_volume,

sum (tx_fee_usd) as Total_TX_Fee,

avg (tx_fee_usd) as Average_TX_Fee,

median (tx_fee_usd) as Median_TX_Fee

from ethereum.core.ez_nft_sales

where origin_to_address = '0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b'

and price_usd > 0

and project_name is not null

group by 1

order by Tokens_Count DESC

limit 10