Structure of the ORDERS table
Structure of the CUSTOMERS table

-Which of the following SQL statements will display all customers who have not recently placed an order?
A) SELECT customer# FROM customers UNION SELECT customer# FROM orders;
B) SELECT customer# FROM orders MINUS SELECT customer# FROM customers;
C) SELECT customer# FROM orders INTERSECT SELECT customer# FROM customers;
D) SELECT customer# FROM customers MINUS SELECT customer# FROM orders;

Question

​
Structure of the ORDERS table
  Structure of the CUSTOMERS table
​
-Which of the following SQL statements will display all customers who have not recently placed an order?​
A) ​SELECT customer# FROM customers UNION SELECT customer# FROM orders; 
B) ​SELECT customer# FROM orders MINUS SELECT customer# FROM customers; 
C) ​SELECT customer# FROM orders INTERSECT SELECT customer# FROM customers; 
D) ​SELECT customer# FROM customers MINUS SELECT customer# FROM orders;

Quizplus · Accepted Answer

We want to display all customers who have not recently placed an order, so we need to select all customers from the CUSTOMERS table and minus (D) the customers who have recently placed an order from the ORDERS table. Options A and C are incorrect because they involve the UNION and INTERSECT operators, which do not help us achieve our desired result. Option B is incorrect because it selects customers who have recently placed an order, rather than those who have not.

​ Structure of the ORDERS Table

Structure of the ORDERS Table