Contents of the ORDERS Table

question 54

Multiple Choice

Contents of the ORDERS table

-Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will display all orders shipped between April 4,2003 and April 5,2003?​

• A) ​SELECT * FROM orders WHERE shipdate <= '04-APR-03' AND shipdate >= '05-APR-03';
• B) ​SELECT * FROM orders WHERE shipdate BETWEEN '04-APR-03' AND '05-APR-03';
• C) ​SELECT * FROM orders WHERE shipdate >= '04-APR-03' AND shipdate <= '05-APR-03';
• D) ​both b and c