How do i make a three months report of the activity from a user?

[Joaquín Lopetegui]

I am doing a query to the database to obtain the audit log and I am missing how to filter it by the results of the last three months and hit the query.

Using this query as a reference:

SELECT a.ACTION AS ACCION,a.CATEGORY as CATEGORIA,a.USER_NAME AS USUARIO,a.RESOURCES as OBJETOMODIFICADO,a.ENTITY_TIMESTAMP as TIEMPO
FROM AO_C77861_AUDIT_ENTITY a, CWD_MEMBERSHIP b
WHERE
a.USER_NAME = b.CHILD_NAME
AND
b.LOWER_PARENT_NAME = 'jira-administrators';