SQL & PL/SQL

Hi Guys,

I need one help to write a query. how to get data for 30,60 and 90 days using below query. I want to get all (for 30,60,90 days) with one query, and based on that I need to insert or update data in another table.

SELECT act_app.actor_id actor_id

    FROM actor_app_assn act_app,

      hr_empl hr_emp,

      actor act

    WHERE act.emp_id = hr_emp.emplid

    AND hr_emp.empl_status = 'A' --active

    AND act_app.actor_id  = act.actor_id  

    AND appl_id = 123 --''US Users'

  MINUS

  SELECT users_id actor_id,

  FROM t_user_audit

  WHERE create_date > sysdate - 30;

Thanks in advance!

Rgrds,

KL