SELECT TO_VARCHAR(BLOCK_TIMESTAMP::DATE, 'yyyy-MM') "Month", COUNT(DISTINCT(ORIGIN_FROM_ADDRESS)) "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'

GROUP BY "Month"),

Uniswap_Polygon AS (

SELECT TO_VARCHAR(BLOCK_TIMESTAMP::DATE, 'yyyy-MM') "Month", COUNT(DISTINCT(ORIGIN_FROM_ADDRESS)) "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'

GROUP BY "Month")

SELECT Sushiswap_Polygon."Month", "Number of users on Sushiswap", "Number of users on Uniswap",

"Number of users on Sushiswap"/"Number of users on Uniswap" AS "The ratio of the number of users in SushiSwap to UniSwap"

FROM Sushiswap_Polygon JOIN Uniswap_Polygon USING("Month")