​Contents of ORDERS Table

question 41

Multiple Choice

​Contents of ORDERS table
Note: Column names are truncated as follows: SH = SHIPSTATE and SHIPZ = SHIPZIP.
-​Based upon the contents of the ORDERS table,which of the following SQL statements will display the number of days between the date an order was placed and the date it was shipped?

• A) SELECT order#,TO_CHAR(shipdate-orderdate,'99')FROM orders WHERE shipdate IS NOT NULL;
• B) SELECT order#,MONTHS_BETWEEN(shipdate-orderdate,'99')FROM orders WHERE shipdate IS NOT NULL;
• C) SELECT order#,ADD_MONTHS(shipdate-orderdate,'99')FROM orders WHERE shipdate IS NOT NULL;
• D) SELECT order#,DAYS_BETWEEN(shipdate-orderdate,'99')FROM orders WHERE shipdate IS NOT NULL;