select

split_part(pool_name, '-', 1) as pool,

count(*) number_trans

from thorchain.defi.fact_liquidity_actions

group by pool_name

)

select

replace(pool,'/','.') as pool_name_up ,

from tb1