Updated 2023-05-14
    with table1 as (
    select SELLER_address as SELLER,
    count (distinct tx_hash) as TX_Count,
    count (distinct tokenid) as Tokens_Count,
    sum (price_usd) as USD_Value,
    sum (price) as ETH_Value
    FROM ethereum.core.ez_nft_sales
    where EVENT_TYPE = 'sale' and CURRENCY_SYMBOL = 'ETH' and NFT_ADDRESS=lower('0x960b7a6bcd451c9968473f7bbfd9be826efd549a')


    group by 1)

    select avg(TX_Count),
    avg (Tokens_Count),
    avg (USD_Value),
    avg (ETH_Value)
    from table1
    Run a query to Download Data