Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST_LAST_NAME is Roberts and CREDIT_LIMIT is 600?

View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables. There is only one customer with the cus_last_name column having value Roberts. Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST_LAST_NAME is Roberts and CREDIT_LIMIT is 600?

View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables. There is only one customer with the cus_last_name column having value Roberts. Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST_LAST_NAME is Roberts and CREDIT_LIMIT is 600?

A.
INSERT INTO orders VALUES (l.’10-mar-2007\ ‘direct’. (SELECT customerid
FROM customers
WHERE cust_last_iiame=’Roberts’ AND
credit_limit=600). 1000);

B.
INSERT INTO orders (order_id.order_date.order_mode. (SELECT customer id
FROM customers
WHERE cust_last_iiame=’Roberts’ AND
redit_limit=600).order_total)
VALUES(L’10-mar-2007′. ‘direct’, &&customer_id, 1000):

C.
INSERT INTO(SELECT o.order_id. o.order_date.o.order_modex.customer_id. o.ordertotal
FROM orders o. customers c
WHERE o.customer_id = c.customerid
AND c.cust_la$t_name-RoberTs’ ANDc.credit_liinit=600)
VALUES (L’10-mar-2007\ ‘direct’.( SELECT customer_id
FROM customers
WHERE cust_last_iiame=’Roberts’ AND
credit_limit=600). 1000);

D.
INSERT INTO orders (order_id.order_date.order_mode.
(SELECT customer_id
FROM customers
WHERE cust_last_iiame=’Roberts’ AND
credit_limit=600).order_total)
VALUES(l.’10-mar-2007\ ‘direct’. &customer_id. 1000):



Leave a Reply 1

Your email address will not be published. Required fields are marked *


daroldrudolph

daroldrudolph

How does any statement work with periods instead of commas?