SELECT ACTION,

count(TX_STATUS) as transaction_Number

FROM osmosis.core.fact_liquidity_provider_actions

WHERE TX_STATUS LIKE 'SUCCEEDED'

GROUP by ACTION

ORDER BY transaction_Number DESC

),

swaps AS(

SELECT 'swap' as action,

COUNT(TX_ID) transaction_Number

FROM osmosis.core.fact_swaps

WHERE TX_STATUS = 'SUCCEEDED'

SELECT *

FROM join_Pool

UNION ALL

SELECT *

FROM swaps

ORDER BY TRANSACTION_NUMBER DES