FROM osmosis.core.fact_transactions

GROUP by 1)

SELECT POOL_ID[0] as pool_number,

case when pool_number = '1' then 'pool ATOM/OSMO'

when pool_number = '497' then 'pool JUNO/OSMO'

when pool_number = '562' then 'pool LUNC/USTC'

when pool_number = '722' then 'pool EVMOS/OSMO'

when pool_number = '10' then 'pool ATOM/CRO'

when pool_number = '604' then 'pool STARS/OSMO'

when pool_number = '560' then 'pool USTC/OSMO'

when pool_number = '611' then 'pool ATOM/STARS'

when pool_number = '561' then 'pool LUNC/OSMO'

when pool_number = '498' then 'pool ATOM/JUNO' end as pool_specific_name,

count(*) as number_of_LPers

FROM osmosis.core.fact_liquidity_provider_actions

LEFT OUTER JOIN tab1

ON LIQUIDITY_PROVIDER_ADDRESS = tx_from

AND min_time = BLOCK_TIMESTAMP

WHERE NOT tx_from is NULL

GROUP BY 1,2 order by 3 desc limit 10