​ Contents of the PROMOTION Table

question 50

Multiple Choice

​
Contents of the PROMOTION table
Structure of the BOOKS table
-Which of the following SQL statements will display the gift that should be sent to any customer who orders the book titled SHORTEST POEMS?​

• A) SELECT gift FROM promotion WHERE gift = minretail;
• B) SELECT gift FROM promotion,books WHERE retail >= minretail AND title = 'SHORTEST POEMS';
• C) SELECT gift FROM promotion,books WHERE retail BETWEEN minretail AND maxretail AND title = 'SHORTEST POEMS';
• D) ​none of the above

---

Definitions:

Job Descriptions

Detailed explanations of the responsibilities, duties, qualifications, and reporting relationships of a particular job.

Organizational Rating Forms

Tools or documents used to assess the performance, skills, or qualifications of individuals within an organization.

Performance Appraisals

The evaluation process through which an employee’s job performance is assessed, typically by their superior, against predefined criteria.

Disciplinary Information

Data pertaining to the actions taken against individuals or entities for violating rules, policies, or expected behaviors.