Question

We need to analyze how long your orders take to be shipped from the date that the order is placed. To do this, you must create a repo
displays the customer number, date ordered, date shipped, and the number of months in whole numbers from the time th
is placed to the time the order is shipped. Which statement produces the required results?
64885
Select one:
O a SELECT custid, orderdate, shipdate,
ROUNDOFF(shipdate - orderdate) "Time Taken"
FROM ord;
O b. SELECT custid, orderdate, shipdate,
MONTHS_BETWEEN (shipdate, orderdate)"Time Taken"
FROM ord;
O c. SELECT custid, orderdate, shipdate,
ROUND(MONTHS_BETWEEN (shipdate, orderdate))
"Time Taken" FROM ord;
O d. SELECT custid, orderdate, shipdate,
ROUND(DAYS_BETWEEN (shipdate, orderdate))/30) "Time Taken"
FROM ord;
64895

Answer 1

You need to analyze how long your orders take to be shipped from the date that the order is placed. To do this, you must create a report that displays the customer number, date ordered, date shipped, and the number of months in whole numbers from the time the order is placed to the time the order is shipped.

Which statement produces the required results?

 

Option A

A.    SELECT custid, orderdate, shipdate,

ROUNDOFF(shipdate - orderdate) "Time Taken" FROM ord;

 

Option B

B.    SELECT custid, orderdate, shipdate,

MONTHS_BETWEEN (shipdate, orderdate)"Time Taken"

FROM ord;

 

Option C

C.    SELECT custid, orderdate, shipdate,

ROUND(DAYS_BETWEEN (shipdate, orderdate))/ 30) "Time Taken" FROM ord;

 

Option D

D.    SELECT custid, orderdate, shipdate,

ROUND(MONTHS_BETWEEN (shipdate, orderdate))

"Time Taken" FROM ord