update eds_us_lake_cdp.cdp_job_log set Average_Run = round(avg(Duration) OVER(partition by job_id ORDER BY Job_Start_Date_Time RANGE BETWEEN INTERVAL 29 DAY PRECEDING AND CURRENT ROW), 2)

I have this query but it's thhrowing error. Anything we can do on it.