Consider the relations shown in the exhibit. Which of the following SQL statements would enter data from the Customers r
Posted: Sat Jul 23, 2022 7:29 pm
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?
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
- Consider The Re 1 (180.98 KiB) Viewed 63 times
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