Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will return all orders shipped within three days after the order was received? A) SELECT * FROM orders WHERE shipdate-orderdate = 3; B) SELECT * FROM orders WHERE shipdate-orderdate = 3; D) SELECT * FROM orders WHERE shipdate-orderdate

Question

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will return all orders shipped within three days after the order was received? A) SELECT * FROM orders WHERE shipdate-orderdate >= 3; B) SELECT * FROM orders WHERE shipdate-orderdate =< 3; C) SELECT * FROM orders WHERE NOT shipdate-orderdate => 3; D) SELECT * FROM orders WHERE shipdate-orderdate <= 3;

Quizplus · Accepted Answer

The query "SELECT * FROM orders WHERE shipdate-orderdate <= 3;" will return all orders where the ship date is within three days after the order date. The other options use incorrect comparison operators or syntax.

Contents of the ORDERS Table