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

Wealthy Countries

Nations with high levels of economic productivity, income per capita, and quality of life.

Welfare State

A system in which the government undertakes to protect the health and well-being of its citizens, especially those in financial or social need, by means of grants, pensions, and other benefits.

Health Care

Organized provisions of medical services to individuals or communities, including preventative, curative, palliative, and rehabilitative care.

Unemployment Insurance

A government-provided insurance that offers financial assistance to individuals who have lost their jobs through no fault of their own.