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