WITH MAIN as (
select
DISTINCT BUYER_ADDRESS as Buyer,
PLATFORM_FEE_usd as FEES_IN_USD
from ethereum.core.ez_nft_sales
where block_timestamp >= '2022-01-01'
and PLATFORM_NAME='opensea'
group by 1,2
)
select
Buyer,
sum(FEES_IN_USD) as volume
from main
where FEES_IN_USD is not null
group by 1
order by 2 desc
limit 10