Contents of the ORDERS Table

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