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 SELECT statements will retrieve all orders contained in the ORDERS table that have not yet been shipped to the customer?​

A) ​SELECT * FROM orders WHERE shipdate = NULL;
B) ​SELECT * FROM orders WHERE shipdate > NULL;
C) ​SELECT * FROM orders WHERE shipdate LIKE 'NULL';
D) ​none of the above