count (DISTINCT tx_hash) as "Total trades",

count(DISTINCT ORIGIN_FROM_ADDRESS) as "Total users",

min(price_usd) as "Min trading volume (USD)",

avg(price_usd) as "Avg trading volume (USD)",

max(price_usd) as "Max trading volume (USD)",

sum(price_usd) as "Total trading volume (USD)",

min(price) as "Min trading volume (ETH)",

avg(price) as "Avg trading volume (ETH)",

max(price) as "Max trading volume (ETH)",

sum(price) as "Total trading volume (ETH)",

sum(TOTAL_FEES) as "TOTAL FEES (ETH)",

sum(TOTAL_FEES_USD) as "TOTAL FEES (USD)"

from base.nft.ez_nft_sales

where nft_address = lower('0xEe7D1B184be8185Adc7052635329152a4d0cdEfA')

and price <= '100'

and price <> '0'