SELECT pool_ids, count(tx_id) AS tx_no

from osmosis.core.fact_swaps

WHERE block_timestamp >= '2022-05-01'

group by pool_ids

order by Tx_no desc

limit 10

),

tbl2 AS (