distinct value as contracts,

count(distinct tx_id) as counts

from osmosis.core.fact_swaps , table(flatten(input => pool_ids )) where block_timestamp between '2022-05-01' and CURRENT_DATE-1

group by 1 order by 2 desc

limit 10