a as (

select

TX_HASH ,

BUYER_ADDRESS ,

TX_FEE

from ethereum.core.ez_nft_sales

where EVENT_TYPE='sale' and PLATFORM_name ='opensea' and BLOCK_TIMESTAMP::date > '2022-01-01'

)

select

count(distinct TX_HASH) as txs ,

count(distinct BUYER_ADDRESS) as buyers ,

sum(TX_FEE) as fee

from a