avg(price) as avg_sale,

median(price) as med_price,

min(price) as min_price,

max(price) as max_price,

max_price-min_price as bond_price,

avg(price_usd) as avg_sale_usd,

median(price_usd) as med_price_usd,

min(price_usd) as min_price_usd,

max(price_usd) as max_price_usd,

max_price_usd-min_price_usd as bond_price_usd

from ethereum.core.ez_nft_sales

where NFT_ADDRESS='0x716f29b8972d551294d9e02b3eb0fc1107fbf4aa'