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%';

Question

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%';

Quizplus · Accepted Answer

The query in option C specifies 'Atlanta' and 'Seattle' with capital letters, whereas the contents of the ORDERS table have these city names in all uppercase letters. Therefore, the WHERE condition in option C will not match any rows in the ORDERS table and will not list any orders shipped to Atlanta or Seattle. Options A, B, and D will all list orders shipped to Atlanta or Seattle.

Contents of the ORDERS Table