​ Structure of the ORDERS Table

question 36

Multiple Choice

​
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;

---

Definitions:

Crowdsourcing

Outsourcing aspects of a decision process to a large collection of people.

Open Innovation

An approach to innovation that stresses the importance of collaboration with external partners and the exchange of knowledge to spur creativity and new developments.

External Sources

Information or inputs that come from outside an organization or individual's immediate environment.

Open Innovation

A business model that encourages sharing ideas and improvements among diverse organizations, communities, or individuals to drive technology and product development.