sakineh5021-nIQRzBSushi Farming 2
    Updated 2022-04-06
    with pool as (
    SELECT pool_name , pool_address
    from ethereum.dex_liquidity_pools
    where platform = 'sushiswap'
    )
    SELECT pool_name , sum(amount_usd) as TVL
    from ethereum.erc20_balances B, pool P
    where user_address = pool_address
    and balance_date = '2022-04-06'
    and amount_usd is not null
    group by 1
    order by 2 DESC

    Run a query to Download Data