faraz-Lvyyy8which stable coin prefer MATIC, number of the transaction
    Updated 2022-09-28
    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
    Run a query to Download Data