Based upon the contents of the BOOK_ORDER table shown below, which of the follow

Question

Based upon the contents of the BOOK_ORDER table shown below, 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? (Points : 4)
SELECT order#, TO_CHAR(shipdate-orderdate, '99') FROM book_order
WHERE shipdate IS NOT NULL;
SELECT order#, MONTHS_BETWEEN(shipdate-orderdate, '99') FROM book_order
WHERE shipdate IS NOT NULL;
SELECT order#, ADD_MONTHS(shipdate-orderdate, '99') FROM book_order
WHERE shipdate IS NOT NULL;
SELECT order#, DAYS_BETWEEN(shipdate-orderdate, '99') FROM book_order
WHERE shipdate IS NOT NULL;

Explanation / Answer

SELECT order#, ADD_MONTHS(shipdate-orderdate, '99') FROM book_order WHERE shipdate IS NOT NULL

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

---