SELECT POOL_ADDRESS , POOL_NAME

FROM ethereum.dex_liquidity_pools

where platform ='sushiswap'

) ,

per as (

SELECT POOL_NAME , balance_date , max(balance) as max_LP ,sum(balance) as total , max_LP/total*100 as percent

from ethereum.erc20_balances

left outer join pool P on POOL_ADDRESS = contract_address

where POOL_NAME is not NULL

and balance is not null

and balance_date >'2021-01-01'

group by 1 , 2

)

SELECT balance_date , count(POOL_NAME)

from per

where percent <=50

group by 1