LIQUIDITY_PROVIDER_ADDRESS as Users

,sum (amount/pow(10,decimal)) as volume2

from osmosis.core.fact_liquidity_provider_actions

where tx_status = 'SUCCEEDED'

group by users

order by volume2 desc