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:

Social Comparison

The process by which individuals evaluate their own opinions, abilities, and traits by comparing themselves to others.

Perspective Taking

The ability to understand and consider the thoughts, feelings, and viewpoints of others.

Physically Handicapped

A term referring to individuals with physical disabilities that limit their activities or movements.

Mentally Retarded

An outdated and offensive term previously used to describe individuals with significant limitations in intellectual functioning and adaptive behavior.