SELECT DATE_TRUNC('WEEK', BLOCK_TIMESTAMP::DATE) AS "Week",CONCAT(Pool_Name, ' - ', Contract_Address) Pool_Name ,COUNT((POOL_NAME)) "Number of swaps"

FROM polygon.sushi.ez_swaps

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

AND POOL_NAME IS NOT NULL

GROUP BY "Week", POOL_NAME, Contract_Address),

RANK_POOLS AS (

SELECT "Week", Pool_Name, "Number of swaps",

RANK() OVER(PARTITION BY "Week" ORDER BY "Number of swaps" DESC) Rank

FROM Sushiswap_Polygon_Pools

SELECT * FROM RANK_POOLS WHERE Rank = 1