Ali3NAverage RENGA NFTs Seller Stats
    Updated 2022-10-10
    with maintable as (
    select seller_address,
    count (distinct tx_hash) as Sales_Count,
    count (distinct tokenid) as Tokens_Count,
    sum (price_usd) as Total_USD_Volume
    from ethereum.core.ez_nft_sales
    where nft_address = '0x394e3d3044fc89fcdd966d3cb35ac0b32b0cda91'
    and price_usd > 0
    group by 1)

    select avg (sales_count), avg(tokens_count), avg (total_usd_volume)
    from maintable
    Run a query to Download Data