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 SQL statements will list all orders placed by customer # 1020 that have not yet been shipped?​

A) ​SELECT * FROM orders WHERE customer# = 1020 OR shipdate = NULL;
B) ​SELECT * FROM orders WHERE customer# = 1020 AND shipdate IS NULL;
C) ​SELECT * FROM orders WHERE customer# = 1020 OR shipdate IS NULL;
D) ​SELECT * FROM orders WHERE customer# = 1020 AND shipdate = NULL;