目前我只会查询一个周之内的数据(定值),但是我想要查到当周往前推两周往后推九周的数据,这该怎么写?SELECT a.DIVISION_NAME, e.fmweek, COUNT (a.CUSTOMER_DEMAND_DATE) 按期交付个数FROMWR_OPC_investment_info c INNER JOIN WR_OPC_Pre_investment_info b ON b.PROJECT_NO = c.PROJECT_NOINNER JOIN WR_OPC_Forecast_info a ON b.OPPORTUNITY_NO = a.OPPORTUNITY_NOINNER JOIN MDM_DIVISION d ON a.DIVISION_NO=d.DIVISION_NOINNER JOIN MDM_TIME e ON a.CUSTOMER_DEMAND_DATE=e.fdateWHEREto_char(a.CUSTOMER_DEMAND_DATE,'yyyyMM') = '202010'--月份and e.fmweek ='2020101' --2020十月第一周and ((C.ACTUAL_END_DATE is not NUll ) OR (C.PLAN_END_DATE is not NUll ))AND to_char(C.ACTUAL_END_DATE,'yyyyMMdd') <= to_char(A.CUSTOMER_DEMAND_DATE,'yyyyMMdd') GROUP BY a.DIVISION_NAME,e.fmweek ORDER BY e.fmweek因为往后推九周是没有数据的,得查其他的三张表