select buyer_address as Buyers,

count (distinct tx_hash) as tx

from ethereum.core.ez_nft_sales

where nft_address in ('0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb', -- CryptoPunks

'0xb7f7f6c52f2e2fdb1963eab30438024864c313f6') -- WPUNKS

and buyer_address != '0x0000000000000000000000000000000000000000'

and price_usd > 0 and price > 0

group by 1),

selltable as (

select seller_address as Seller,

count (distinct tx_hash) as tx1

from ethereum.core.ez_nft_sales

where nft_address in ('0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb', -- CryptoPunks

'0xb7f7f6c52f2e2fdb1963eab30438024864c313f6') -- WPUNKS

and seller_address != '0x0000000000000000000000000000000000000000'

and price_usd > 0 and price > 0

group by 1)

select buyers as Trader,

sum (tx+tx1) as transactions

from buytable t1 join selltable t2 on buyers = seller

group by 1

order by 2 DESC

limit 10