provide_liquidity as (

SELECT tx_hash,

origin_from_address,

p.pool_name

FROM base.core.ez_decoded_event_logs l

JOIN base.defi.dim_dex_liquidity_pools p ON l.contract_address = p.pool_address

WHERE event_name = 'Mint'

AND contract_name = 'BaseSwap LPs'

SELECT COUNT(DISTINCT tx_hash) as transactions, COUNT(DISTINCT origin_from_address) as providers,

FROM provide_liquidity

GROUP BY pool_name

ORDER BY providers DESC

LIMIT 10