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;

Question

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;

Quizplus · Accepted Answer

The SQL statement should include the customer number and the condition that the shipdate is NULL, indicating that the order has not yet been shipped. Option A and C include records with shipdate as NULL, even if they are not associated with customer #1020. Option D only includes records with both customer #1020 and NULL shipdate, but does not account for orders that have not been shipped yet with a non-NULL shipdate. Therefore, option B is the only correct statement.

Contents of the ORDERS Table