WHEN contract='LUM-OSMO' THEN 'OSMO-LUM'

WHEN contract='USDC.axl-EVMOS' THEN 'EVMOS-USDC.axl'

WHEN contract='ATOM-DVPN' THEN 'DVPN-ATOM'

WHEN contract='DVPN-OSMO' THEN 'OSMO-DVPN'

WHEN contract='USDC.axl-ATOM' THEN 'ATOM-USDC.axl'

WHEN contract='LUNC-OSMO' THEN 'OSMO-LUNC'

WHEN contract='JUNO-ATOM' THEN 'ATOM-JUNO'

WHEN contract='USDC.axl-OSMO' THEN 'OSMO-USDC.axl'

WHEN contract='ATOM-EVMOS' THEN 'EVMOS-ATOM'

WHEN contract='LUNC-ATOM' THEN 'ATOM-LUNC'

WHEN contract='JUNO-OSMO' THEN 'OSMO-JUNO'

WHEN contract='USTC-OSMO' THEN 'OSMO-USTC'

WHEN contract='USTC-ATOM' THEN 'ATOM-USTC'

ELSE contract END as contracts,

sum(n_user) as n_users,

sum(n_txn) as n_txns

(SELECT b.project_name || '-' || c.project_name as contract,

count(DISTINCT a.trader) as n_user,

count(DISTINCT a.tx_id) as n_txn

FROM osmosis.core.fact_swaps a

LEFT JOIN osmosis.core.dim_labels b

ON a.from_currency = b.address

LEFT JOIN osmosis.core.dim_labels c

ON a.to_currency = c.address

WHERE date_Trunc('day',a.block_timestamp) >= '2022-05-01'

GROUP BY contract

GROUP BY contracts

ORDER BY n_users DESC