SELECT
DISTINCT LIQUIDITY_PROVIDER_ADDRESS as "uniqe users",
sum(AMOUNT/ pow(10,18)) as "Total LP Amount"
FROM osmosis.core.fact_liquidity_provider_actions
WHERE POOL_ID = '9'
AND block_timestamp >= '2022-09-24'
AND action = 'lp_tokens_burned'
AND tx_status = 'SUCCEEDED'
group by 1
order by 2 desc
limit 10