Contents of the ORDERS table

-Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will display all orders that were not shipped for at least three days after the order was received?
A) SELECT * FROM orders WHERE shipdate-orderdate = 3;
B) SELECT * FROM orders WHERE shipdate-orderdate = 3;
C) SELECT * FROM orders WHERE NOT shipdate-orderdate = 3;
D) SELECT * FROM orders WHERE NOT shipdate-orderdate = 3;

Question

Contents of the ORDERS table
 
-Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will display all orders that were not shipped for at least three days after the order was received?​
A) ​SELECT * FROM orders WHERE shipdate-orderdate => 3; 
B) ​SELECT * FROM orders WHERE shipdate-orderdate >= 3; 
C) ​SELECT * FROM orders WHERE NOT shipdate-orderdate => 3; 
D) ​SELECT * FROM orders WHERE NOT shipdate-orderdate >= 3;

Quizplus · Accepted Answer

The query should retrieve all orders where the difference between shipdate and orderdate is greater than or equal to 3. This will ensure that orders that were not shipped for at least three days after the order was received are included. Option A has a syntax error and uses the wrong operator, whereas option C and D use the NOT operator, which will exclude the desired results.

Contents of the ORDERS Table