SELECT

pool_address

FROM ethereum.core.dim_dex_liquidity_pools

WHERE pool_name LIKE '%WETH%'

AND platform LIKE 'sushiswap'

SELECT

date_trunc('day', block_timestamp),

count(*) as LP_events,

count(DISTINCT origin_from_address) as liquidty_providers

FROM ethereum.core.fact_event_logs

WHERE contract_address in (SELECT * from tab1)

AND event_name LIKE 'Mint'

GROUP BY 1