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:

Population Mean

The average value of a set of characteristics for an entire population.

Alpha

A threshold value in hypothesis testing that determines the level of significance, usually set to 0.05 or 0.01.

Type I Error

An error in hypothesis testing that occurs when the null hypothesis is wrongly rejected, falsely indicating a significant result.

Two-tailed Hypothesis

A hypothesis test that considers both directions of an effect, allowing for the possibility of difference in either direction from the null hypothesis.