Structure of the CUSTOMERS Table

question 44

Multiple Choice

Structure of the CUSTOMERS table
​
Structure of the ORDERS table
Structure of the ORDERITEMS table
Structure of the BOOKS table
-Which of the following SQL statements will display the title of all books that have had multiple copies requested in a single order?​

• A) ​SELECT title FROM books NATURAL JOIN orderitems WHERE qty > 1;
• B) ​SELECT title FROM books JOIN orderitems WHERE qty > 1;
• C) ​SELECT title FROM books JOIN orderitems ON (isbn)JOIN orders ON (order#) WHERE qty>1;
• D) ​SELECT title FROM books JOIN orderitems USING(isbn);

---

Definitions:

Social Entrepreneurship

The practice of starting businesses with the aim of resolving social problems or effecting social change.

Wei-Skillern Model

A theoretical framework in the nonprofit management field that suggests networks and collaboration among nonprofit organizations contribute to greater impact and efficiency in achieving their missions.

Nonprofit Organization

Not-for-profit entities that aim to serve public or community interests, typically reinvesting excess revenue in their mission rather than distributing it as profit.

Awaaz Foundation

An NGO based in India that focuses on environmental and social issues, known for its work in noise pollution advocacy among other causes.