select count (*) as contador,EXTRACT(MONTH FROM CREATION_TIME) as mes,
 EXTRACT(YEAR FROM CREATION_TIME) as anio
FROM TABLA p WHERE CAMPO=1 AND BORRADO=0
GROUP BY EXTRACT(YEAR FROM CREATION_TIME),EXTRACT(MONTH FROM CREATION_TIME) ORDER BY anio,mes ASC;


Devolver el contador de campo a buscar agrupados por año