anomoneAvg gas fees per transactions
    Updated 2022-11-28
    SELECT CASE WHEN (TO_LABEL= 'sushiswap' or FROM_LABEL = 'sushiswap' )THEN 'Sushiswap' ELSE 'Uniswap' END as "Platform",
    avg(tx_fee) as "Avg Gas Fee per Txn in ETH" , avg(fee_usd) as "Avg Gas Fee per Txn in USD" FROM ethereum.transactions
    where --tx_id = '0x477628c71e27abee051ac19b7e3d4bda87797f1bd843d21ae1c90221ceb9011e'
    (TO_LABEL= 'sushiswap' or FROM_LABEL = 'sushiswap' or TO_LABEL= 'uniswap' or FROM_LABEL = 'uniswap' )
    GROUP BY CASE WHEN (TO_LABEL= 'sushiswap' or FROM_LABEL = 'sushiswap' )THEN 'Sushiswap' ELSE 'Uniswap' END
    Run a query to Download Data