Name

ORDER# CUSTOMER# ORDERDATE

SHIPDATE SHIPSTREET SHIPCITY SHIPSTATE

SHIPZIP

Structure of the ORDERS table

$+$ Oracle SQL$$Plus

File Edit Search Options Help

Nane

CUSTOMER# LASTNAME

FIRSTNAME

ADDRESS

CITY

STATE

ZIP

REFERRED

Hu$11?$

Type

NOT NULL NUMBER$(4)$

NUMBER$4$

DATE DATE

VARCHAR$2(18)$

VARCHAR$2(15)$

VARCHAR$2(2)$

VARCHAR$2(5)$

Null?

Type

NOT HULL

NUMBER$(4)$

VARCHAR$2(10)$

VARCHAR$2(10)$

VARCHAR$2(20)$

VARCHAR$2(12)$

VARCHAR$2(2)$

VARCHAR$2(5)$

NUNIBER$4$

Structure of the CUSTOMERS table

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

$$ SELECT $*$ FROM orders, customers;

$$ 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