WITH lp as (SELECT
liquidity_provider,
SUM(CASE WHEN is_active = 'TRUE' THEN liquidity_adjusted ELSE 0 END) as total_liquidity,
pool_name
FROM uniswapv3.positions
WHERE pool_name LIKE 'USDC-WETH%'
AND is_active = 'TRUE'
GROUP BY 1,3
ORDER BY 2 DESC
LIMIT 10)