Contents of the ORDERS Table

question 21

Multiple Choice

Contents of the ORDERS table

-Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will not list the orders that have been shipped to Atlanta or Seattle?​

• A) ​SELECT * FROM orders WHERE shipcity = 'ATLANTA' OR shipcity = 'SEATTLE';
• B) ​SELECT * FROM orders WHERE shipcity IN ( 'ATLANTA' ,'SEATTLE');
• C) ​SELECT * FROM orders WHERE shipcity = 'Atlanta' OR shipcity = 'Seattle';
• D) ​SELECT * FROM orders WHERE shipcity LIKE 'AT%' OR shipcity LIKE 'SEA%';

---

Definitions:

Secondary Group

A larger, more impersonal group that usually has specific goals, involving formal, impersonal relationships among its members.

Emotional Support

Refers to the assistance, comfort, and reassurance provided to individuals to help them cope with stress, emotional distress, or trauma.

Personal Network

The web of social relationships that surround an individual, including friends, family, and acquaintances.

Job Listing

An advertisement or announcement of a job opening, describing the position, requirements, and how to apply.