Contents of the ORDERS Table

Multiple Choice

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%';