Name

Edit

ORDER# CUSTOMER# ORDERDATE

SHIPDATE SHIPSTREET

SHIPCITY SHIPSTATE SHIPZIP

Search

Options Help

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

Nane

CUSTOMER# LASTNAME

FIRSTNAME ADDRESS

CITY STATE

ZIP

REFERRED

Null?

Type

NOT NULL NUMBER$(4)$

VARCHAR$2(10)$

VARCHAR$2(10)$

VARCHAR$2(20)$

VARCHAR$2(12)$

VARCHAR$2(2)$

VARCHAR$2(5)$

NUMBER$4$

Structure of the CUSTOMERS table

Which of the following SQL statements will display all customers who have not recently placed an order? SELECT customer# FROM customers

UNION

SELECT customer# FROM orders;

$$ SELECT customer# FROM orders

MINUS

SELECT customer# FROM customers;

$$ SELECT customer# FROM orders

INTERSECT

SELECT customer# FROM customers;

$$ SELECT customer# FROM customers

MINUS

SELECT customer# FROM orders;