SELECT 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 Pool_Name, Contract_Address),

RANK_POOLS AS (

SELECT Pool_Name, "Number of swaps"

FROM Sushiswap_Polygon_Pools ORDER BY "Number of swaps" DESC LIMIT 5

SELECT * FROM RANK_POOLS