blockchain AS Blockchain,

CASE

WHEN POSITION('-' IN pool_name) > 0 THEN SPLIT_PART(pool_name, '-', 1)

WHEN POSITION('~' IN pool_name) > 0 THEN SPLIT_PART(pool_name, '~', 1)

WHEN POSITION('/' IN pool_name) > 0 THEN SPLIT_PART(pool_name, '/', 1)

ELSE pool_name

END AS PoolName,

COUNT(DISTINCT tx_id) AS SwapCount

thorchain.defi.fact_swaps

GROUP BY

Blockchain,

PoolName

ORDER BY

SwapCount DESC

10;