【单选题】
Examine the data from the ORDERS and CUSTOMERS table.<br /> ORDERS<br /> ORD_ID ORD_DATE CUST_ID ORD_TOTAL<br /> 100 12-JAN-2000 15 10000<br /> 09-MAR-<br /> 101 40 8000<br /> 09-MAR-<br /> 102 35 12500<br /> 15-MAR-<br /> 103 15 12000<br /> 104 25-JUN-2000 15 6000<br /> 105 18-JUL-2000 20 5000<br /> 106 18-JUL-2000 35 7000<br /> 107 21-JUL-2000 20 6500<br /> 04-AUG-<br /> 108 10 8000<br /> CUSTOMERS<br /> CUST_ID CUST_NAME CITY<br /> 10 Smith Los Angeles<br /> 15 Bob San Francisco<br /> 20 Martin Chicago<br /> 25 Mary New York<br /> 30 Rina Chicago<br /> 35 Smith New York<br /> 40 Linda New York<br /> Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that Martin places his orders?（）<br />
A、SELECT ord_id, cust_id, ord_total FROM orders, customers WHERE cust_name='Mating' AND ord _ date IN ('18-JUL-2000','21-JUL-2000');
B、SELECT ord_id, cust_id, ord_total FROM orders Where ord_date IN (SELECT ord_date FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'MARTIN'));
C、SELECT ord_id, cust_id, ord_total FROM orders Where ord_date IN (SELECT ord_date FROM orders, customers Where cust _ name = 'Martin');
D、SELECT ord_id, cust_id, ord_total FROM orders WHERE cust_id IN (SELECT cust_id FROM customers WHERE cust name = 'Martin');
查看正确答案
