info as (

select

*, value v2

from osmosis.core.fact_swaps , table(flatten(input => pool_ids ))

where block_timestamp>='2022-05-01'

SELECT

v2 as contracts,

count(distinct tx_id) as tx_volume

from info

group by 1

order by 2 desc limit 10