Filter by Selection allows filters based on multiple values in the same field

Excel interprets the date 7/4/11 as 7/4/________

Fill in the blank(s) with correct word

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;