SELECT COUNT(DISTINCT(ORIGIN_FROM_ADDRESS)) "Total number of users on Sushiswap"

FROM polygon.sushi.ez_swaps

WHERE BLOCK_TIMESTAMP::DATE < '2022-10-15' ---BLOCK_TIMESTAMP::DATE BETWEEN '2022-05-12' AND '2022-10-12'

),

Uniswap_Polygon AS (

SELECT COUNT(DISTINCT(ORIGIN_FROM_ADDRESS)) "Total number of users on Uniswap"

FROM polygon.core.fact_event_logs

WHERE BLOCK_TIMESTAMP::DATE < '2022-10-15' AND TX_STATUS = 'SUCCESS' ---BLOCK_TIMESTAMP::DATE BETWEEN '2022-05-12' AND '2022-10-12'

AND ORIGIN_TO_ADDRESS IN ('0xe592427a0aece92de3edee1f18e0157c05861564','0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45') AND EVENT_NAME = 'Swap'

)

SELECT 'Sushiswap' AS Type, "Total number of users on Sushiswap" AS Value FROM Sushiswap_Polygon

UNION

SELECT 'Uniswap' AS Type, "Total number of users on Uniswap" AS Value FROM Uniswap_Polygon