'https://basescan.org/address/' || SELLER_ADDRESS AS SELLER_ADDRESS,

count(distinct tx_hash) as nft_sales ,

count(distinct tokenid) ,

sum(price) as price_eth,

sum(price_usd) as price_usd,

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('0x6e230533d53e2f8fb90c542f02e5fa306b1fe1d3')

group by 1

order by 2 desc

offset 1 rows FETCH first 10 rows only