Contents of the ORDERS Table

question 74

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