Contents of the ORDERS table

-Based upon the contents of the ORDERS table in the accompanying figure,which of the following SQL statements will display how long it took to ship order # 1007 (based upon when the order was originally placed)?
A) SELECT order#,shipdate-orderdate FROM orders WHERE order# = 1007;
B) SELECT order#,shipdate-orderdate FROM orders WHERE order# LIKE 1_7%;
C) SELECT order#,shipdate-orderdate FROM orders WHERE order# = 1_7%;
D) SELECT order#,shipdate-orderdate FROM orders WHERE order# LIKE '1_7%';

Question

Contents of the ORDERS table
 
-​Based upon the contents of the ORDERS table in the accompanying figure,which of the following SQL statements will display how long it took to ship order # 1007 (based upon when the order was originally placed)?
A) ​SELECT order#,shipdate-orderdate FROM orders WHERE order# = 1007; 
B) ​SELECT order#,shipdate-orderdate FROM orders WHERE order# LIKE 1_7%; 
C) ​SELECT order#,shipdate-orderdate FROM orders WHERE order# = 1_7%; 
D) ​SELECT order#,shipdate-orderdate FROM orders WHERE order# LIKE '1_7%';

Quizplus · Accepted Answer

Option A is correct because it directly queries for order #1007 and calculates the difference between the shipdate and orderdate, which is the intended operation to find out how long it took to ship the order.

Contents of the ORDERS Table