YEAR(CREATION_TIME) AS year,

CASE

WHEN MONTH(CREATION_TIME) = 1 THEN 'January'

WHEN MONTH(CREATION_TIME) = 2 THEN 'February'

WHEN MONTH(CREATION_TIME) = 3 THEN 'March'

WHEN MONTH(CREATION_TIME) = 4 THEN 'April'

WHEN MONTH(CREATION_TIME) = 5 THEN 'May'

WHEN MONTH(CREATION_TIME) = 6 THEN 'June'

WHEN MONTH(CREATION_TIME) = 7 THEN 'July'

WHEN MONTH(CREATION_TIME) = 8 THEN 'August'

WHEN MONTH(CREATION_TIME) = 9 THEN 'September'

WHEN MONTH(CREATION_TIME) = 10 THEN 'October'

WHEN MONTH(CREATION_TIME) = 11 THEN 'November'

WHEN MONTH(CREATION_TIME) = 12 THEN 'December'

END AS month_name,

COUNT(*) AS pools_created

FROM ethereum.defi.dim_dex_liquidity_pools

WHERE YEAR(CREATION_TIME) = YEAR(CURRENT_DATE()) -- Filter for this year

GROUP BY YEAR(CREATION_TIME), MONTH(CREATION_TIME)

ORDER BY MONTH(CREATION_TIME) ASC;