SELECT TO_VARCHAR(BLOCK_TIMESTAMP::DATE, 'yyyy-MM') "Month", COUNT(DISTINCT(TX_HASH)) "Number of swaps 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(TX_HASH)) "Number of swaps 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 swaps on Sushiswap", "Number of swaps on Uniswap",

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

FROM Sushiswap_Polygon JOIN Uniswap_Polygon USING( "Month")