'https://basescan.org/address/' || BUYER_ADDRESS AS BUYER_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('0x5470da6d5b35c4a0be5243822db7cf6f861f13e6')

group by 1

order by 2 desc

offset 1 rows FETCH first 10 rows only