Consider the relations shown in the exhibit. Which of the following SQL statements would enter data from the Customers relation into the Atlanta_Customers relation?
Consider The Re 1 (180.98 KiB) Viewed 60 times
A. INSERT INTO Atlanta_Customers VALUES( SELECT * FROM Customer s WHERE Sales_Office = Atlanta
B. INSERT INTO Atlanta_Customers SELECT * FROM Customers WHERE Sales_Office = Atlanta
C. INSERT INTO Atlanta_Customers SELECT Cust_No, Cust_Name, Satisfaction_Rate, Sales_Rep_No FROM Customers WHERE Sales_Office = Atlanta
D. INSERT INTO Atlanta_Customers SELECT Cust_No, Cust_Name, Sales_Office, Sales_Rep_No FROM Customers WHERE Sales_Office = Atlanta
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!