with USDC as (
select --SYMBOL_IN,
count(TX_HASH) AS NUMBER
from ethereum.core.ez_dex_swaps
where SYMBOL_OUT = 'USDC'
and SYMBOL_IN = 'MATIC'
--GROUP by 1
--order by 1
--MATIC
--0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0
),
USDT as (
select --SYMBOL_IN,
count(TX_HASH) AS NUMBER
from ethereum.core.ez_dex_swaps
where SYMBOL_OUT = 'USDT'
and SYMBOL_IN = 'MATIC'
--GROUP by 1
--order by 1
--MATIC
--0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0
),
DAI as (
select --SYMBOL_IN,
count(TX_HASH) AS NUMBER
from ethereum.core.ez_dex_swaps
where SYMBOL_OUT = 'DAI'
and SYMBOL_IN = 'MATIC'
-- GROUP by 1
--order by 1
--MATIC
--0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0
)
select 'USDC TO MATIC' as ACTION_NAME ,NUMBER from USDC
UNION
select 'USDT TO MATIC' as ACTION_NAME ,NUMBER from USDT