Fetch users who have NOT logged in since past 30/60/90 days and send reminder email

Summary:

Fetch users who have NOT logged in since past 30/60/90 days and send reminder email

Content (required):

I need to fetch list of users who have NOT logged in since past 30/60/90 days. Using below snippet for 30 days. I am using same query in bursting and able to send mails. How do I modify the date condition so that I can use ESS Job to send emails.

Version (include the version you are using, if applicable):it

Code Snippet (add any code snippets that support your topic, if applicable):

select 

pea.EMAIL_ADDRESS,

pu.USERNAME,

TO_CHAR(auli.LAST_LOGIN_DATE,'mm-dd-yyyy') LAST_LOGIN_DATE,