SELECT
DATE_TRUNC('MONTH', BLOCK_TIMESTAMP) AS creation_month,
COUNT(DISTINCT SERVICE_ID) AS monthly_services_created,
SUM(COUNT(DISTINCT SERVICE_ID)) OVER (
ORDER BY
DATE_TRUNC('MONTH', BLOCK_TIMESTAMP)
) AS cumulative_services_created
FROM
crosschain.olas.ez_service_registrations
WHERE
BLOCK_TIMESTAMP >= DATEADD(YEAR, -1, CURRENT_DATE)
GROUP BY
creation_month
ORDER BY
creation_month;