count(DISTINCT tx_hash) as sales,

COUNT(DISTINCT BUYER_ADDRESS) as buyers,

sum(PRICE_USD) as sales_volume,

median(PRICE_USD) as median_price

FROM optimism.core.ez_nft_sales

WHERE nft_address LIKE lower('0x0deaAc29d8A3d4EbBAAa3eCd3cC97C9deF00f720')