Name

ORDER# CUSTOMER# ORDERDATE

SHIPDATE SHIPSTREET

SHIPCITY SHIPSTATE SHIPZIP

Null?

Type

NOT NULL NUMBER$(4)$

NUMBER$(4)$

DATE DATE

VARCHAR$2(18)$

VARCHAR$2(15)$

VARCHAR$2(2)$

VARCHAR$2(5)$

Structure of the ORDERS table

$+$ Oracle SQL Plus

File

Edit Search Options Help

Name

$--=---.$

Null?

Type

CUSTOMER#

$--------$

LASTNAME

NOT NULL NUMBER$(4)$

FIRSTNAME

VARCHAR$2(10)$

ADDRESS

VARCHAR$2(10)$

CITY

VARCHAR$2(20)$

STATE

VARCHAR$2(12)$

ZIP

VARCHAR$2(2)$

REFERRED

VARCHAR$2(5)$

NUMBER $(4)$

Structure of the CUSTOMERS table

Which of the following queries will display data from both the ORDERS and CUSTOMERS tables?

O SELECT $*$ FROM orders, customers;

O SELECT lastname, firstname, order#

FROM orders NATURAL JOIN customers;

$$ SELECT lastname, firstname, order#

FROM orders, customers

WHERE orders.customer#$=$ customers.customer#;

$$ all of the above