'Liquidity Added' as actions,

sum(amount_usd) as volume_usd

from ethereum.core.ez_eth_transfers a

join ethereum.core.dim_dex_liquidity_pools b on a.eth_to_address = b.pool_address and b.platform = 'sushiswap'

where not tx_hash in (select tx_hash from ethereum.sushi.ez_swaps where block_timestamp > '2022-09-01')

and eth_to_address in (select contract_address from ethereum.sushi.ez_swaps)

and block_timestamp > '2022-09-15'

group by 1

select pool_name,

'Liquidity Added',

sum(amount_usd)

from ethereum.core.ez_token_transfers a

join ethereum.core.dim_dex_liquidity_pools b on a.to_address = b.pool_address and b.platform = 'sushiswap'

where not tx_hash in (select tx_hash from ethereum.sushi.ez_swaps where block_timestamp > '2022-09-01')

and to_address in (select contract_address from ethereum.sushi.ez_swaps)

and block_timestamp > '2022-09-15'

group by 1)

select *,

row_number () over (order by volume_usd desc) as count

from table_1

where volume_usd > 0

order by 3 desc

limit 10