Contents of the ORDERS table

-Based upon the contents of the ORDERS table in the accompanying figure,which of the following SQL statements will display all orders contained in the ORDERS table that have been shipped to the customer?
A) SELECT * FROM orders WHERE shipdate = 'NOT NULL';
B) SELECT * FROM orders WHERE shipdate = NOT NULL;
C) SELECT * FROM orders WHERE shipdate IS NULL;
D) SELECT * FROM orders WHERE shipdate IS NOT 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 display all orders contained in the ORDERS table that have been shipped to the customer?​
A) ​SELECT * FROM orders WHERE shipdate = 'NOT NULL'; 
B) ​SELECT * FROM orders WHERE shipdate = NOT NULL; 
C) ​SELECT * FROM orders WHERE shipdate IS NULL; 
D) ​SELECT * FROM orders WHERE shipdate IS NOT NULL;

Quizplus · Accepted Answer

The SQL statement "SELECT * FROM orders WHERE shipdate IS NOT NULL" will display all orders that have a shipdate recorded in the table, indicating that they have been shipped to the customer. Choices A and B have incorrect syntax as "NOT NULL" should not be in quotes. Choice C will display orders that have not been shipped yet (i.e. have a null shipdate). Thus, option D is the best choice for displaying all shipped orders.

Contents of the ORDERS Table