View the Exhibit and examine the structure of the ORDERS table.
You have to display ORDER_ID, ORDER_DATE, and CUSTOMER_ID for all those orders that were placed after the last order placed by the customer whose CUSTOMER_ID is 101 Which query would give you the desired output?
A. SELECT order id, order_date FROM ordersWHERE order_date > ALL (SELECT MAX(order_date)FROM orders) ANDCustomer_id = 101;
B. SELECT order id, order_date FROM ordersWHERE order_date > ANY (SELECT order_dateFROM ordersWHERE customer_id = 101);
C. SELECT order _id, order_date FROM ordersWHERE order_date > ALL (SELECT order_dateFROM ordersWHERE customer_id = 101);
D. SELECT order id, order_date FROM ordersWHERE order_date IN (SELECT order_dateFROM ordersWHERE customer id = 101);
|
Download Printable PDF. VALID exam to help you PASS. |
 |