Contents of ORDERS table

$+$ Oracle SQL$\backslash$deg Plus

Fle

Edit Search Options Help

ORDER#

CUSTOMERE ORDERDATE SHIPDATE

SHIPSTREET

$-------$A$-$

SHIPCITY

SH SHIPZ

$1000$

$1005$

$31-$MAR$-0231-$MAR$-021201$ ORANGE AVE

SEATTLE

WA

$98114$

$1001$

$101031-$MAR$-02$

$01-$APR$-02114$ EAST SAVANHAH

ATLANTA

GA $30314$

$1002$

$1911$

$31-$HAR$-02$

$01-$APR$-0258$ TILA CIRCLE

CHICAGO

IL

$60605$

$1003$

$1001$

$01-$APR$-0201-$APR$-02958$ MAGNOLIA LANE

EASTPOINT

FL $32328$

$1004$

$1020$

$01-$APR$-02$

$05-$APR$-02561$ ROUNDABOUT WAY TRENTON

NJ $08601$

$1005$

$1018$

$01-$APR$-02$

$02-$APR$-021008$ GRAND AVENUE

MACON

GA $31286$

$1006$

$1003$

$01-$APR$-02$

$02-$APR$-92558$A CAPITOL HUY.

TALLAHASSEE

FL

$32307$

$1007$

$1007$

$02-$APR$-02$

$04-$APR$-029153$ MAIN STREET

AUSTIN

TX $78710$

$1008$

$1004$

$02-$APR$-02$

$03-$APR$-0269821$ SOUTH AVENUE

BOISE

ID

$83707$

$1009$

$1005$

$03-$APR$-02$

$05-$APR$-029$ LIGHTENING RD$.$

SEATTLE

WA

$98110$

$1010$

$1019$

$03-$APR$-02$

$04-$APR$-02$

$384$ WRONG WAY HOME MORRISTOWN

NJ

$07960$

$1011$

$1010$

$03-$APR$-02$

$05-$APR$-02$

$102$ WEST LAFAYETTE ATLANTA

GA

$30311$

$012$

$1017$

$03-$APR$-02$

$1295$ WINDY AVENUE

KALMAZOO

MI

$49002$

$1013$

$1014$

$03-$APR$-02$

$04-$APR$-02$

$7618$ MOUNTAIN RD$.$

CODY

WY

$82414$

$1007$

$04-$APR$-02$

$05-$APR$-029153$ MAIN STREET

AUSTIN

TX $78710$

$1020$

$04-$APR$-02$

$557$ GLITTER ST$.$

TRENTON

NJ

$08606$

$1003$

$04-$APR$-02$

$9901$ SEMINOLE WAY

TALLAHASSEE

FL

$32307$

$1015$

$04-$APR$-02$

$05-$APR$-02887$ HOT ASPHALT ST

MIAMI

FL

$33112$

$1018$

$1001$

$05-$APR$-02$

$95812$ HIGHWAY

$98$

EASTPOINT

FL

$32328$

$1019$

$1018$

$05-$APR$-02$

$1008$ GRAND

AUENUE

MACON

GA $31206$

$1020$

$1008$

$05-$APR$-02$

$195$ JAMISON LANE

CHEYENNE

$82083$

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?

O SELECT order#$,$ TO$\_$CHAR$($shipdate$-$orderdate, $\text{'}99\text{'})$ FROM orders

WHERE shipdate IS NOT NULL;

$$ SELECT order#$,$ MONTHS$\_$BETWEEN$($shipdate$-$orderdate, $\text{'}99\text{'})$ FROM orders

WHERE shipdate IS NOT NULL;

$$ SELECT order#$,$ ADD $\_$MONTHS$($shipdate$-$orderdate, $\text{'}99\text{'})$ FROM orders

WHERE shipdate IS NOT NULL;

O SELECT order#$,$ DAYS $\_$BETWEEN$($shipdate$-$orderdate, $\text{'}99\text{'})$ FROM orders

WHERE shipdate IS NOT NULL;

esc

$!$

@

#