Structure of the CUSTOMERS Table

question 62

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 books that have not been ordered recently?​

• A) ​SELECT title FROM books,orderitems WHERE books.isbn <> orderitems.isbn;
• B) ​SELECT title FROM books NATURAL JOIN orderitems WHERE JOIN IS NULL;
• C) ​SELECT title FROM books NATURAL JOIN orderitems MINUS SELECT title FROM books;
• D) ​SELECT title FROM books MINUS SELECT title FROM books NATURAL JOIN orderitems;

---

Definitions:

Units Started

The number of production units that have begun the manufacturing process within a specific period.

FIFO Method

A stock valuation method where the first items purchased or produced are the first ones removed from inventory, standing for "First-In, First-Out".

Conversion Costs

The combination of labor and overhead expenses incurred to transform raw materials into finished products.

Grinding Department

A production segment within a manufacturing facility where materials are ground, refined, or processed.