YOU HAVE A TABLE NAMED ORDERS THAT CONTAINS THE ORDERID, CUSTOMERI...

16. You have a table named Orders that contains the OrderID, CustomerID, Amount, and OrderDate columns. You must retrieve all orders placed in the last seven days. What criteria should you use with the WHERE clause (select all that apply)?A. WHERE DateDiff(“week”, OrderDate, GETDATE( )) <= 1B. WHERE DateDiff(“day”, OrderDate, GETDATE( )) <= 7C. WHERE GetDate(“day”, OrderDate, DATEDIFF( )) <= 7D. WHERE GetDate(“day”, OrderDate, DATEDIFF( )) >= 7