from ethereum.core.dim_dex_liquidity_pools

where PLATFORM='sushiswap')

SELECT

TO_ADDRESS,

count(distinct TO_ADDRESS) as total_LP_removers,

count(tx_hash) as no_txn,

sum(amount_usd) as volume

from ethereum.core.ez_token_transfers

where FROM_ADDRESS in (select POOL_ADDRESS from tb1)

and ORIGIN_TO_ADDRESS='0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f'

and origin_function_signature in ('0xbaa2abde', '0x2195995c', '0x02751cec')

and BLOCK_TIMESTAMP<'2022-09-15' and BLOCK_TIMESTAMP>='2022-09-01'-- before merge

and TO_ADDRESS!='0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f'

group by 1 having volume is not null

order by 4 desc limit 10