seller_address,

count(distinct tx_hash) as sale_count,

-- count(distinct buyer_address) as buyers_count,

sum(price) as sale_volume,

sum(platform_fee) as opensea_fee,

sum(creator_fee) as basepaint_fee,

sale_volume - opensea_fee - basepaint_fee as profit

from base.nft.ez_nft_sales

where nft_address = '0xd68fe5b53e7e1abeb5a4d0a6660667791f39263a'

group by 1

order by profit DESC